DBA Data[Home] [Help]

SYS.DBMS_XQUERY dependencies on XMLTYPE

Line 3: FUNCTION eval(xqry varchar2) return xmltype is

1: PACKAGE BODY dbms_xquery AS
2:
3: FUNCTION eval(xqry varchar2) return xmltype is
4: pragma autonomous_transaction;
5: rval xmltype := null;
6: begin
7: execute immediate 'select xmlquery(:1 returning content) from dual'

Line 5: rval xmltype := null;

1: PACKAGE BODY dbms_xquery AS
2:
3: FUNCTION eval(xqry varchar2) return xmltype is
4: pragma autonomous_transaction;
5: rval xmltype := null;
6: begin
7: execute immediate 'select xmlquery(:1 returning content) from dual'
8: into rval using xqry;
9: commit;