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
Pinned topic Question about extractclob function
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-07-10T02:17:11Z at 2009-07-10T02:17:11Z by SystemAdmin
SystemAdmin 110000D4XK228 Posts
Re: Question about extractclob function2009-07-10T02:17:11ZThis is the accepted answer. This is the accepted answer.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.