2 Replies Latest reply on Dec 18, 2013 5:38 AM by Bob

    need to extract payloads in xml format stored in Oracle DB.

    Bob

      Hi All,

       

      we want to extract payloads in xml format stored in Oracle DB.

      we have gone through oracle note:

      Note:1541887.1 How To Access The Instance Payload From The SOA Dehydration Store In Readable Format.

      it suggests to use

      select utl_raw.cast_to_varchar2(dbms_lob.substr(document,500,1)) from xml_document where <your where criteria>;

      but we are able to extract only 500 character with this query. our requirement is to extract complete xml from database.

      Please help.

       

      TIA,

      Bob