Home » Developer & Programmer » JDeveloper, Java & XML » loading xml file
loading xml file [message #301535] Thu, 21 February 2008 00:12 Go to next message
Messages: 53
Registered: January 2008
I have emp.xml file which consist of emp table field. I want to load that xml file to target table(semp which is create table semp as select *from emp where 1=2).
To load this xml file i am written procedure to load xml file in emp_xml table( create table emp_xml col1 sys.xmltype) and extract the field from emp_xml table and load to semp table.

Can anyone tell me how i load this xml file to semp table without storing the emp_xml table. that means a procedure which take input one directory name, and xml file name in run time and load the xml file into a semp table;
Re: loading xml file [message #301569 is a reply to message #301535] Thu, 21 February 2008 01:06 Go to previous message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know if it works but have a look at DBMS_LOB.LOADFROMFILE.

Previous Topic: How ILoading .xml into target table
Next Topic: error occurring in java source
Goto Forum:

Current Time: Sun May 26 01:04:26 CDT 2024