OraFAQ Forum: JDeveloper, Java & XML » Loading very LARGE xml file into oracle database relational table

Home » Developer & Programmer » JDeveloper, Java & XML » Loading very LARGE xml file into oracle database relational table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading very LARGE xml file into oracle database relational table [message #159748]

Tue, 21 February 2006 03:36

pawansinghal
Messages: 3
Registered: February 2006

Junior Member

Hi,

I want to upload a very large XML file into the oracle table. The size of the XML file may be upto 100 MB. There might be many documents (purchase orders) in the XML file. Lots of validation and conditions are required to upload the file as all the contents are not required to be uploaded in the table. There are around 70-80 attribute on one purchase order. The conditions are also defined in the xml file itself.

I am currently trying to upload a small file with the attached code. Could you please let me know what is the best way to upload the large xml file. It shouldn't burst the memory of the server.

The attached file is not the complete code.

Please anyone help me.

Thanks

Attachment: pr_process_xml_file.sql
(Size: 6.66KB, Downloaded 1586 times)

Report message to a moderator

Previous Topic:	Problems with jdevelopper DataTable
Next Topic:	jdbc, Thin ==> ORA-01017: invalid username/password; logon denied

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 08:05:17 CST 2024