Oracle DBMS_SQLJTYPE
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Java class and type validation
AUTHID DEFINER
Dependencies Only STANDARD
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;

SELECT dbms_sqljtype.validatetype('/11351672_minimizegif', USER) FROM dual;

Related Topics
DBMS_JAVA
DBMS_JAVA_DUMP
Java Functions
Packages
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved