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 will be available on generic Linux platforms in January and soon on AIX and Windows

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