Try to load a xml file with no error but nothing was loaded
Hello,
I try to load a xml file (no very big) to an Oracle table by SQL Loader. Here is what in control file:
OPTIONS ( DIRECT=TRUE)
LOAD DATA
INFILE *
INTO TABLE BOLINF.XX_IPP_INV_XML_TABLE
REPLACE
XMLTYPE (XMLCONTENT)
(
fill filler char(1),
creation_date sysdate,
XMLCONTENT lobfile(CONSTANT '//interface/infnehui/DNEH1I/ipp/inv_file_transfer/inv_file.xml') TERMINATED BY EOF
)
begindata
0
When I run it, there is no error and the message is 'Load completed - logical record count 1'.
However, when I check the table by following query, it seems like nothing was loaded: