Home » Developer & Programmer » JDeveloper, Java & XML » How ILoading .xml into target table (oracle 9i or 10g)
How ILoading .xml into target table [message #301519] Wed, 20 February 2008 23:23
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
Previous Topic: XML extraction and character encoding error?
Next Topic: loading xml file
Goto Forum:
  


Current Time: Thu Mar 28 04:06:00 CDT 2024