HI All,
I just want to load a XML file into a table which we recieve on daily basis.he File_ID value should increment everytime a new value comes and File Name should be populated from File as the File name will have date stamp attached to it.
OPTIONS ( skip=1)
LOAD DATA
infile 'C:\Users\HVentrap\Desktop\INVCTL\STATUS*.xml'
INTO TABLE PQINF.XXPQ_EDI_INV_STS_FILE
(FILE_ID "XXPQ_EDI_INV_STS_F.NEXTVAL"
,FILE_NAME
,DELIVERY_FILE
,PROCESS_FLAG "N"
,CREATION_DATE "SYSDATE"
,CREATED_BY "FND_GLOBAL.USER_ID"
,LAST_UPDATE_DATE "SYSDATE"
,LAST_UPDATED_BY "FND_GLOBAL.USER_ID"
)
CREATE TABLE XXPQ_EDI_INV_STS_FILE
(
FILE_ID NUMBER,
FILE_NAME VARCHAR2(200 BYTE),
DELIVERY_FILE SYS.XMLTYPE,
PROCESS_FLAG VARCHAR2(1 BYTE),
CREATION_DATE DATE,
CREATED_BY NUMBER,
LAST_UPDATE_DATE DATE,
LAST_UPDATED_BY NUMBER
)
Attached sample XML File for reference.PLease suggest how Can I do this
] 
Blog
Search
Help
Members
Register
Login
Home
