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

    XML XQuery

      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" ?>

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