Oracle DBMS_SQLJTYPE
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_JAVA
DBMS_JAVA_DUMP
Java Functions
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx