Hi,
I've always loaded a list of XML files into a table by using SQL Loader.
On the server UNIX first I created a file containing a list of path where I have N XML files and then I run some CTL like this:
load data
infile ".../list.dat" stream
badfile ".../list.bad"
append
into MYTABLE
fields terminated by ','
trailing nullcols
(id sequence(max,1),
file_name char(150),
file_xml lobfile(file_name) terminated by eof
)
Could someone tell me how to get that by using an external table?
Thanks in advance!
Mark