PL/SQL (MOSC)

MOSC Banner

Try to load a xml file with no error but nothing was loaded

edited Apr 4, 2019 7:40AM in PL/SQL (MOSC) 7 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center