Oracle | DBMS_SQLJTYPE

Oracle DBMS_SQLJTYPE Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

      AQAPI_BUILT_ON_ADE_LABEL_RDBMS_21.0.0.0.0_LINUX.X64_201030

      AQAPI_BUILT_WITH_RDBMS_VERSION_21.0.0.0.0

      JAVA$CBHASH$A6849219

      JAVA$CBRLS$21.0.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

      

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

      

      DBMS_SQLJTYPE.VALIDATETYPE('META-INF/LICENSE.TXT',USER)

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

                                                    
      107