Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert large xml file to XMLType column?

548016Jun 8 2012 — edited Jun 23 2012

Hi,

I have a table with one column as XMLType(Binary XML storage option and Free Text Indexing). When i try to insert a large XML as long as 8kb, i'm getting an error ORA-01704:string literal too long.

Insert into TEST values(XMLTYPE('xml HERE'));

How to insert large XML values to XMLType column?

Regards,
Sprightee

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 21 2012

Added on Jun 8 2012

#jdbc, #oracle, #performance-availability, #query, #xml, #xml-db

9 comments

12,344 views