Topic
  • 1 reply
  • Latest Post - ‏2009-07-10T02:17:11Z by SystemAdmin
SystemAdmin
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 :
<employee>
<givenname>Roy</givenname>
<familyname>Connor</familyname>
<address>
<address1>123 First Street</address1>
<city>Denver</city>
<state/>CO</state>
<zipcode>80111</zipcode>
</address>
<phone>303-555-1212</phone>
</employee>

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
    SystemAdmin
    228 Posts

    Re: Question about extractclob function

    ‏2009-07-10T02:17:11Z  
    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.
    http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.xml.doc/ids_xppublishing.html