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

解决方案 »

  1.   

    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                     VALIDCATPROC
    Oracle Database Packages and Types
    11.2.0.1.0                     VALIDCOMP_ID
    ------------------------------
    COMP_NAME
    --------------------------------------------------------------------------------
    VERSION                        STATUS
    ------------------------------ ----------------------JAVAVM
    JServer JAVA Virtual Machine
    11.2.0.1.0                     VALID
      

  2.   

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