Oracle Database Discussions

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!

Extracting raw xml file stored in CLOB column from oracle database table

gkcreddyFeb 15 2018 — edited Feb 16 2018

Hello everyone,

I have a situation where I need extract the XML file which is stored as a raw file into a CLOB column in Oracle database table.

Is there a way to extract the raw file? I tried to extract the file using UTL_FILE but it is extracting the binary data stored in the CLOB column. Anyone faced similar kind of requirement and is there any inputs?

Thank you in advance.

Chakri

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2018

Added on Feb 15 2018

#general-database-discussions

8 comments

2,271 views