Home » Developer & Programmer » JDeveloper, Java & XML » loading xml file
loading xml file [message #301535] Thu, 21 February 2008 00:12 Go to next message
someswar1
Messages: 53
Registered: January 2008
Member
Hi,
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;
regards:
someswar
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: 64117
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.

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


Current Time: Tue Dec 06 04:23:45 CST 2016

Total time taken to generate the page: 0.06378 seconds