1 Reply Latest reply: Dec 15, 2006 11:06 AM by 475314 RSS

    XML Parsing using PL/SQL

    468672
      Hi,

      Here's the situation :

      I've XML " data " (not as file ) stored as CLOB in a table,
      I need to parse this data and extract the attributes from that data using PL/SQL.

      Any suggestions.. Please post !!
      thanks..
        • 1. Re: XML Parsing using PL/SQL
          475314
          So You have XML (file) content in a CLOB field :) Use XMLType and XML DB functions, etc...

          XMLType API is at

          http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96616/arxml24.htm

          and also check it out at

          http://www.oracle.com/technology/tech/xml/xmldb/index.html

          and some samples are at

          http://www.oracle.com/technology/sample_code/tech/xml/xmldb/index.html