• 1 reply
  • Latest Post - ‏2009-07-10T02:17:11Z by SystemAdmin
228 Posts

Pinned topic Question about extractclob function

‏2009-07-09T09:21:35Z |
Hi all,

I am testing the XML publishing feature of ids 11.5, i have created a table with a CLOB column to store the XML message, 1 of the record was inserted as follow:
INSERT INTO epr_xml_publishing_clob VALUES('200001',FILETOCLOB('c:\clob.xml', 'client'),CURRENT);

where the content of clob.xml is :
<address1>123 First Street</address1>

When i try to use the sql statement to retrieve the xml content, "SQL Error (-8355): extractvalueclob" prompt out from the server studio. Please kindly advise on this.

SELECT extractvalueclob(msg_content,'/employee/phone') FROM epr_xml_publishing_clob
Updated on 2009-07-10T02:17:11Z at 2009-07-10T02:17:11Z by SystemAdmin
  • SystemAdmin
    228 Posts

    Re: Question about extractclob function

    Sorry for my careless mistake, i found that the reason is due to the <state/>CO</state>, as i just copy the sample xml form the follow link. The problem solved.