SQL & PL/SQL

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 data from oracle into XML

483845Sep 15 2006 — edited Sep 19 2006

We have a table in oracle that one of its column is CLOB and it contains more than 4K data. We want to extract all the data contained in that column type CLOB and have them displayed in XML.

Since the data size >4K, using XMLElement failed.

I'd really appreciate any assistance in dealing with this specific problem or with the general issue of trying to insert large CLOB data from oracle to XML using PL/SQL.

Thank you for your help in advance !

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 17 2006

Added on Sep 15 2006

10 comments

571 views