Loading Data Using sqlldr
Chat, July 10, 2024 - 10:27 pm UTC
Hello Chris,
Thank you for the reply.
I am using a control file to load my xml data. It works as expected, but it adds an empty row/record to the Oracle Table. Eg. I have 3 records in my data file. When I insert these 3 records into the table, it gives me 4 records. Last record doesn't have any data in it. How can I stop inserting the fourth record.
I copied the control file I used below. Please let me know your thoughts.
load data
infile 'C:\Chat\chat_SORTS_data.xml' -- "str '</CRIME>'"
append
into table XML_DATA_IMPORT_CHAT_TMP
TRAILING NULLCOLS
( XHSQ_XML_MESSAGE LOBFILE( CONSTANT 'C:\Chat\chat_SORTS_data.xml') TERMINATED BY '[XML]' )
Thanks,
Chat
July 11, 2024 - 12:35 pm UTC
What exactly is in the XML file?
useful
A reader, July 22, 2024 - 2:08 am UTC
Could you provide an example SQL Loader script that I can use as a starting point for my automation process?
July 22, 2024 - 12:37 pm UTC