6 Replies Latest reply on Mar 24, 2015 6:23 PM by Yoav

    Only LOB or String Storage is supported in Thin XMLType

    Yoav

      Hi,

      XML statment failed on the following message in Sql Developer :Version 4.1.0.18

      "Only LOB or String Storage is supported in Thin XMLType"

       

      But , is run successfully from sqlplus :

       

      SQL>  SELECT XMLQuery('declare namespace pd="http://xmlns.tibco.com/bw/process/2003"; (:

        2   $p/pd:ProcessDefinition/pd:group/pd:activity/config' passing XML as "p" returning content)

        3   from canon.bezeq_xml_tab

        4   where document_id='997834';

       

      XMLQUERY('DECLARENAMESPACEPD="HTTP://XMLNS.TIBCO.COM/BW/PROCESS/2003";(::)$P/PD:PROCESSDEFINITION/PD

      ----------------------------------------------------------------------------------------------------

      <config>

        <faultName/>

      </config>

      <config>

        <faultName/>

      </config>

      <config>

        <

       

      Please advise

      Thanks