7 Replies Latest reply on Feb 28, 2013 12:52 PM by Devid

    XML XQuery

    Devid
      Hi Experts,

      I am beginner in XML programming with PL/SQL.
      when i am going to extract data from XMLTYPE column then some error is showing as:

      ORA-19114: error during parsing the XQuery expression:
      ORA-06550: line 1, column 13:
      PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored


      my script is :



      create table test (xdata xmltype);

      insert into test(xdata)
      values (
      '<?xml version="1.0" encoding="UTF-8" ?>
      <data>
      <name>Vivek</name>
      </data>'
      );


      select * from test,
      xmltable('/data'
      passing xdata
      columns data_name varchar2(20) path '@name'
      );