Home » SQL & PL/SQL » SQL & PL/SQL » Inserting / Reading More than 32kb XML File from OS
Inserting / Reading More than 32kb XML File from OS [message #249145] Tue, 03 July 2007 09:00 Go to next message
Messages: 1
Registered: July 2007
Location: PUNE
Junior Member
Dear All
I need to insert XML document in to Table whose file size is more than 32KB. i have written a code which can insert upto 32KB sucessfully. but after 32KB limitation it fails I have read that DBMS_LOB can handle this but i dont know how to use it.
We have created directory also and these procedures are working fine for databelow 32KB. Kindly guide how i can use DBMS_LOB in this Procedures, Kindly go through Attachments
and waiting for reply

Re: Inserting / Reading More than 32kb XML File from OS [message #251368 is a reply to message #249145] Fri, 13 July 2007 06:19 Go to previous message
Messages: 4
Registered: March 2007
Junior Member
Hi Atul,
Sending you code which can read file more than 32kb
hope this will help you out. in this script i have created addition table called xmldocument (id number, XML_TEXT clob);

Arvind Shinde
  • Attachment: reply.txt
    (Size: 3.26KB, Downloaded 229 times)

[Updated on: Fri, 13 July 2007 06:22]

Report message to a moderator

Previous Topic: How to select field A having more than one field B with diffrent values ?
Next Topic: Getting all the Records from the Database
Goto Forum:

Current Time: Thu Oct 27 10:40:34 CDT 2016

Total time taken to generate the page: 0.11013 seconds