Oracle | DBMS_SQLJTYPE

Oracle DBMS_SQLJTYPE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Java class and type validation

AUTHID DEFINER

Dependencies

STANDARD (only)

Documented No

First Available 2000-2001

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmssjty.sql

Subprograms

VALIDATECLASS

VALIDATETYPE

VALIDATECLASS

Validates a JAVA Class dbms_sqljtype.validateclass( supertoid IN RAW, schemaName IN VARCHAR2, className IN VARCHAR2) RETURN NUMBER;

TBD

VALIDATETYPE

Validates a JAVA Type dbms_sqljtype.validatetype( typeName IN VARCHAR2, schemaName IN VARCHAR2) RETURN NUMBER;

SELECT object_name

      FROM dba_objects_ae

      WHERE owner = 'SYS'

      AND object_type = 'JAVA RESOURCE'

      AND rownum < 11;

      

      
      OBJECT_NAME

      ------------------------------------------

      AQAPI_BUILT_BY_JDK_VERSION_8

      JAVA$CBHASH$A6849219

      JAVA$CBRLS$23.2.0.0.0.0 1.8

      
      META-INF/LICENSE.txt

      META-INF/MANIFEST.MF

      META-INF/gfprobe-provider.xml

      META-INF/hk2-locator/default

      META-INF/javamail.charset.map

      META-INF/javamail.default.address.map

      
      META-INF/javamail.default.providers

      
      

      SELECT dbms_sqljtype.validatetype('META-INF/LICENSE.txt', USER);

                                                                    *

      Error at lie 1:

      ORA-04031: out of shared memory in java pool