I want to import an XML file into Oracle using SQL Loader and then extract data once it's loaded. I've found some examples but I cant get it to work.
My xml file is -- ReturnFile.xml (I've attached a sample)
CREATE TABLE XML_INPUT
My Contol File looks like this:
OPTIONS ( DIRECT=TRUE)
INTO TABLE "JVO0"."XML_INPUT"
FIELDS TERMINATED BY ','
RAWXML LOBFILE(ReturnFile) TERMINATED BY EOF
When I run from the command line:
sqlldr jvo0/pw@company direct=true, control=C:\XML.CTL, log=c:\XML.LOG
I get this error:
SQL*Loader-350: Syntax error at line 9.
Expecting "(" , found "XMLTYPE".
Any assistance is appreciated.