提示类不存在！！

[hrbcxcyc]

create or replace procedure GET_XML_NULL(Tmp clob,xmlw out blob)
as
xmlhdl dbms_xmlgen.ctxtype;
xmltext blob;
begin
xmlhdl:= sys.DBMS_XMLQUERY.NewContext(tmp);
sys.DBMS_XMLQUERY.closecontext(xmlhdl);
xmlw:=xmltext;
end;

运行到 xmlhdl:= sys.DBMS_XMLQUERY.NewContext(tmp); 提示
ORA-29540: 类 oracle/xml/sql/query/OracleXMLStaticQuery 不存在
ORA-06512: 在 "SYS.DBMS_XMLQUERY", line 26
ORA-06512: 在 "FYTEST.GET_XML_NULL", line 7
ORA-06512: 在 line 3

[小灰狼W]

select comp_id, comp_name, version, status from DBA_REGISTRY; 检查看看是否安装了javavm组件

[hrbcxcyc]

javavm安装了！

[hrbcxcyc]

SQL> select comp_id, comp_name, version, status from DBA_REGISTRY; COMP_ID ------------------------------ COMP_NAME -------------------------------------------------------------------------------- VERSION STATUS ------------------------------ ---------------------- CATALOG Oracle Database Catalog Views 11.2.0.1.0 VALID CATPROC Oracle Database Packages and Types 11.2.0.1.0 VALID COMP_ID ------------------------------ COMP_NAME -------------------------------------------------------------------------------- VERSION STATUS ------------------------------ ---------------------- JAVAVM JServer JAVA Virtual Machine 11.2.0.1.0 VALID

[小灰狼W]

那么，检查下权限

[hrbcxcyc]

我用dba权限的用户。调用这个也提示ORA-29540: 类 oracle/xml/sql/query/OracleXMLStaticQuery 不存在