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!

Error in select object_value.getCLOBval() in 10G

78282Sep 14 2004 — edited Sep 14 2004

Hi All,
I need to get the XML Doc stored in table and create a XML file for FTP to another machine. I am trying to read the XML as CLOB and write using UTL_FILE. I am getting following error in select object_value.getCLOBval() query on a XMLType column in Oracle 10.1.0.2.0 version. Error is:

ERROR at line 1:
ORA-00904: "OBJECT_VALUE"."GETCLOBVAL": invalid identifier

Any help would be appreciated.
Thanks
Sanksh

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2004

Added on Sep 14 2004

#performance-availability, #xml-db

2 comments

3,170 views