Oracle | DBMS_JAVA Demos, Syntax, and Example Code

Oracle DBMS_JAVA 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 Provides a PL/SQL interface for accessing database functionality from Java.

AUTHID CURRENT_USER

Data Types TYPE compiler_option_type IS RECORD(option_line VARCHAR2(128)); TYPE compiler_option_type_table IS TABLE OF compiler_option_type;

Dependencies

ALL_JAVA_COMPILER_OPTIONS	DBMS_JAVA_DEFINERS	GET_ERROR$
CBA_JAVA_COMPILER_OPTIONS	DBMS_JAVA_MISC	JAVAVM_SYS
DBA_JAVA_COMPILER_OPTIONS	DBMS_JAVA_TEST	JVMRJBCINV
DBA_OBJECTS	DBMS_JVM_EXP_PERMS	PLITBLM
DBJ_SHORT_NAME	DBMS_OUTPUT	USER_JAVA_COMPILER_OPTIONS
DBMS_ASSERT		-1

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-29532	Untrapped Java Exception

First Available With or prior to 10.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/javavm/install/initdbj.sql

Subprograms

COMPILE_CLASS	LONGNAME
COMPILE_METHOD	NATIVE_COMPILER_OPTIONS
DBMS_FEATURE_OJVM	NCOMP_STATUS_MSG
DBMS_FEATURE_SYSTEM_OJVM	OPTION_CONTROLLER
DECODE_NATIVE_COMPILER_OPTION	QUERY_OUTPUT_TO_FILE
DELETE_PERMISSION	QUERY_OUTPUT_TO_JAVA
DERIVEDFROM	QUERY_OUTPUT_TO_SQL
DISABLE_OUTPUT_TO_FILE	QUERY_OUTPUT_TO_TRC
DISABLE_OUTPUT_TO_JAVA	REMOVE_OUTPUT_TO_FILE
DISABLE_OUTPUT_TO_SQL	REMOVE_OUTPUT_TO_JAVA
DISABLE_OUTPUT_TO_TRC	REMOVE_OUTPUT_TO_SQL
DISABLE_PERMISSION	REMOVE_PROPERTY
DROPJAVA	RESET_COMPILER_OPTION
DUMP_NATIVE_MACHINE_CODE	RESET_PROPERTY_DEFS_TABLE_FLAG
ENABLE_OUTPUT_TO_FILE	RESOLVER
ENABLE_OUTPUT_TO_JAVA	RESTRICT_PERMISSION
ENABLE_OUTPUT_TO_SQL	REVOKE_PERMISSION
ENABLE_OUTPUT_TO_TRC	RUNJAVA
ENABLE_PERMISSION	RUNJAVA_IN_CURRENT_SESSION
ENDSESSION	SEND_COMMAND
ENDSESSION_AND_RELATED_STATE	SET_COMPILER_OPTION
END_EXPORT	SET_EXECUTE_PRIVILEGE
END_IMPORT	SET_FIXED_IN_INSTANCE
EXPORT_CLASS	SET_NATIVE_COMPILER_OPTION
EXPORT_RAW_CHUNK	SET_OUTPUT
EXPORT_RESOURCE	SET_OUTPUT_TO_FILE
EXPORT_SOURCE	SET_OUTPUT_TO_JAVA
EXPORT_TEXT_CHUNK	SET_OUTPUT_TO_SQL
FINALIZE_OUTPUT_TO_FILE	SET_PERMISSION_DEBUG
FIXED_IN_INSTANCE	SET_PREFERENCE
FULL_NCOMP_ENABLED	SET_PROPERTY
GETVERSION	SET_RUNTIME_EXEC_CREDENTIALS
GET_COMPILER_OPTION	SET_SYSTEM_CLASS_LOADING
GET_JDK_VERSION	SET_VERIFIER
GET_OJVM_PROPERTY	SHAREDPRIVATECLASSNAME
GET_PROPERTY	SHORTNAME
GET_REPLY	SHOW_PROPERTY
GRANT_PERMISSION	START_BTL
GRANT_POLICY_PERMISSION	START_EXPORT
HOTLOAD_MODULE	START_IMPORT
IMPORT_RAW_CHUNK	START_JMX_AGENT
IMPORT_TEXT_CHUNK	STOP_BTL
INITIALIZE_OUTPUT_TO_FILE	TERMINATE_BTL
INIT_BTL	UNCOMPILE_CLASS
JAR_DIGEST	UNCOMPILE_METHOD
JAR_DIGEST_BYTES	UNHOTLOAD_MODULE
JAR_NAME_FROM_MODULE	UNSET_NATIVE_COMPILER_OPTION
LOADJAVA

COMPILE_CLASS

Compiles all methods defined by the class identified by classname in the current schema dbms_java.compile_class((classname IN VARCHAR2) RETURN NUMBER;

TBD

COMPILE_METHOD

Compile the method specified by name and Java type signature defined by the class identified by classname in the current schema dbms_java.compile_method( classname IN VARCHAR2, methodname IN VARCHAR2, methodsig IN VARCHAR2) RETURB NUMBER;

TBD

DBMS_FEATURE_OJVM

Undocumented dbms_java.dbms_feature_ojvm( ojvm_boolean OUT NUMBER, aux_count OUT NUMBER, ojvm_info OUT CLOB);

TBD

DBMS_FEATURE_SYSTEM_OJVM

Undocumented dbms_java.dbms_feature_system_ojvm( ojvm_boolean OUT NUMBER, aux_count OUT NUMBER, ojvm_info OUT CLOB);

TBD

DECODE_NATIVE_COMPILER_OPTION

Undocumented dbms_java.decode_native_compiler_option( optionName IN VARCHAR2, value IN VARCHAR2) RETURN VARCHAR2;

TBD

DELETE_PERMISSION

Removes an existing row with specified key from the policy table dbms_java.delete_permission(key number) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.security.PolicyTableManager.delete(long)';

TBD

DERIVEDFROM

Undocumented dbms_java.derivedfrom( name IN VARCHAR2, owner IN VARCHAR2, type IN VARCHAR2) RETURN VARCHAR2;

TBD

DISABLE_OUTPUT_TO_FILE

Undocumented dbms_java.disable_output_to_file(id IN VARCHAR2) RETURN VARCHAR2;

TBD

DISABLE_OUTPUT_TO_JAVA

Disables a specification created by set_output_to_java dbms_java.disable_output_to_java(id IN VARCHAR2) RETURN VARCHAR2;

TBD

DISABLE_OUTPUT_TO_SQL

Undocumented dbms_java.disable_output_to_sql(id IN VARCHAR2) RETURN VARCHAR2;

TBD

DISABLE_OUTPUT_TO_TRC

Undocumented dbms_java.disable_output_to_trc;

exec dbms_java.disable_output_to_trc;

      

      PL/SQL procedure successfully completed.

DISABLE_PERMISSION

Undocumented dbms_java.disable_output_to_sql(key IN NUMBER);

TBD

DROPJAVA

Drops classes within the database using a call, rather than through the dropjava command-line tool dbms_java.dropjava(options IN VARCHAR2)AS LANGUAGE JAVA NAME 'oracle.aurora.server.tools.loadjava.DropJavaMain.serverMain(java.lang.string)';

exec dbms_java.dropjava('-s rdbms/jlib/schagent.jar');

DUMP_NATIVE_MACHINE_CODE

Dump the native code (if available) for the specified method to trace dbms_java.dump_native_machine_code( classname IN VARCHAR2, methodname IN VARCHAR2, methodsig IN VARCHAR2);

TBD

ENABLE_OUTPUT_TO_FILE

Undocumented dbms_java.enable_output_to_file(id IN VARCHAR2) RETURN VARCHAR2;

TBD

ENABLE_OUTPUT_TO_JAVA

Enables a specification created by set_output_to_java and subsequently disabled by disable_output_to_java dbms_java.enable_output_to_java(id IN VARCHAR2) RETURN VARCHAR2;

TBD

ENABLE_OUTPUT_TO_SQL

Undocumented dbms_java.enable_output_to_sql(id IN VARCHAR2) RETURN VARCHAR2;

TBD

ENABLE_OUTPUT_TO_TRC

Undocumented dbms_java.enable_output_to_trc;

exec dbms_java.enable_output_to_trc;

      

      PL/SQL procedure successfully completed.

ENABLE_PERMISSION

Undocumented dbms_java.eable_output_to_sql(key IN NUMBER);

TBD

ENDSESSION

Undocumented dbms_java.endsession RETURN VARCHAR2;

TBD

ENDSESSION_AND_RELATED_STATE (new 23ai)

Clears any java session state remaining from previous execution of java in the
current RDBMS session and all supporting data related to running java dbms_java.endsession_and_related_state RETURN VARCHAR2;

SELECT dbms_java.endsession_and_related_state;

      

      ENDSESSION_AND_RELATED_STATE

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

      java session and permanent state ended

END_EXPORT

Undocumented dbms_java.end_export RETURN NUMBER;

TBD

END_IMPORT (new 23ai)

Undocumented dbms_java.end_import RETURN NUMBER;

SELECT dbms_java.end_import;

      

      END_IMPORT

      ----------

               6

EXPORT_CLASS (new 23ai)

Undocumented dbms_java.export_class( name IN VARCHAR2, schema IN VARCHAR2, clz IN BLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportClass( java.lang.String, java.lang.String, oracle.sql.BLOB)';

TBD

EXPORT_RAW_CHUNK (new 23ai)

Undocumented dbms_java.export_raw_chunk( chunk OUT RAW, length OUT NUMBER) RETURN NUMBER;

TBD

EXPORT_RESOURCE (new 23ai)

Undocumented

Overload 1 dbms_java.export_resource( name IN VARCHAR2, schema IN VARCHAR2, res IN BLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportResource( java.lang.String, java.lang.String, oracle.sql.BLOB)';

TBD

Undocumented

Overload 2 dbms_java.export_resource( name IN VARCHAR2, res IN BLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportResource( java.lang.String, oracle.sql.BLOB)';

TBD

Undocumented

Overload 3 dbms_java.export_resource( name IN VARCHAR2, schema IN VARCHAR2, res IN CLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportResource( java.lang.String, java.lang.String, oracle.sql.CLOB)';

TBD

Undocumented

Overload 4 dbms_java.export_resource( name IN VARCHAR2, res IN CLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportResource(java.lang.String, oracle.sql.CLOB)';

TBD

EXPORT_SOURCE (new 23ai)

Undocumented

Overload 1 dbms_java.export_source( name IN VARCHAR2, schema IN VARCHAR2, src IN BLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportSource(java.lang.String, java.lang.String, oracle.sql.BLOB)';

TBD

Overload 2 dbms_java.export_source( name IN VARCHAR2, src IN BLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportSource(java.lang.String, oracle.sql.BLOB)';

TBD

Overload 3 dbms_java.export_source( name IN VARCHAR2, schema IN VARCHAR2, src IN CLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportSource(java.lang.String, java.lang.String, oracle.sql.CLOB)';

TBD

Overload 4 dbms_java.export_source( name IN VARCHAR2, src IN CLOB) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.ExportSchemaObjects.exportSource(java.lang.String, oracle.sql.CLOB)';

TBD

EXPORT_TEXT_CHUNK (new 23ai)

Undocumented dbms_java.export_text_chunk( chunk OUT VARCHAR2, length OUT NUMBER) RETURN NUMBER;

TBD

FINALIZE_OUTPUT_TO_FILE (new 23ai)

Undocumented dbms_java.finalize_output_to_file(id IN VARCHAR2);

TBD

FIXED_IN_INSTANCE (new 23ai)

Undocumented dbms_java.fixed_in_instance( name IN VARCHAR2, owner IN VARCHAR2, type IN VARCHAR2) RETURN NUMBER;

TBD

FULL_NCOMP_ENABLED (new 23ai)

Undocumented dbms_java.full_ncomp_enabled RETURN VARCHAR2;

TBD

GETVERSION

Retrieves the database version dbms_java.getVersion RETURN VARCHAR2;

SELECT dbms_java.getVersion;

      

      GETVERSION

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

      23.8.0.25.2504154.0

GET_COMPILER_OPTION

Returns the current compiler configuration

"what" refers to a source name, package or class. Determine the option value for option optionName applied to "what" dbms_java.get_compiler_option( what IN VARCHAR2, optionName IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_JDK_VERSION

Retrieves the database JDK version dbms_java.get_jdk_version RETURN VARCHAR2;

SELECT dbms_java.get_jdk_version;

      

      GET_JDK_VERSION

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

      11.0.27

GET_OJVM_PROPERTY (new 23ai)

Undocumented dbms_java.get_ojvm_property(propstring VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME java name 'java.lang.System.getProperty(java.lang.String) RETURN java.lang.String';

TBD

GET_PROPERTY (new 23ai)

Returns any value previously established
by set_property, or null if there is no such value dbms_java.get_property(name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_REPLY (new 23ai)

Returns reply chunks from the shell dbms_java.get_reply RETURN LONG RAW;

TBD

GRANT_PERMISSION

Grants Property Permissions

Creates an active row in the policy table granting the permission, as specified, to grantee.

This demo, at right, is courtesy of Ralph Mintel. and, when tested in 11.2.0.1, it was valid. Nothing obvious should prevent it from still being functional. dbms_java.grant_permission( grantee IN VARCHAR2, permission_type IN VARCHAR2, permission_name IN VARCHAR2, permission_action IN VARCHAR2, key OUT NUMBER) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.security.PolicyTableManager.grant( java.lang.String, java.lang.String, java.lang.String, java.lang.String, long[])';

-- ==============================================

      -- Oracle Java Functions

      -- Oracle dba_java_policy

      -- Variation on Tom Kyte's java system properties.

      -- Ralph Mintel Mar. 21, 2008

      -- ==============================================

      

      col name format a40

      col value format a60

      col id format 999

      

      -- =============================================

      -- Function to retrieve all of the java properties.

      -- =============================================

      

      CREATE OR REPLACE FUNCTION jp RETURN VARCHAR2 AUTHID DEFINER IS LANGUAGE JAVA

        NAME 'java.lang.System.getProperties()

        RETURN java.lang.String';

      /

      

      -- =============================================

      -- the following will probably fail with ORA-29532:

      -- Java call terminated by uncaught Java exception:

      -- java.security.AccessControlException:

      -- (java.util.PropertyPermission * read,write)

      -- has not been granted to UWCLASS.

      -- =============================================

      

      SELECT get_java_system_property();

      

      -- =============================================

      -- Grant java PropertyPermission...

      -- =============================================

      conn sys@pdbdev as sysdba

      

      desc dba_java_policy;

      

      exec dbms_java.grant_permission('UWCLASS', 'SYS:java.util.PropertyPermission', '*', 'read,write');

      

      -- =============================================

      -- Back to our user...

      -- =============================================

      

      conn uwclass/uwclass@pdbdev

      

      col name format a40

      col value format a60

      col id format 999

      

      SELECT jp();

      

      -- =============================================

      -- Create a table for these java properties...

      -- =============================================

      

      CREATE TABLE java_properties (

      rid   NUMBER,

      name  VARCHAR2(40),

      value VARCHAR2(660) DEFAULT NULL);

      

      -- =============================================

      -- Insert each java property name-value pair into a table.

      --

      -- The entire block of properties starts with '{'

      -- and ends with '}'.

      --

      -- The property name=value sets are comma delimited.

      -- '=' separates the name and value.

      -- =============================================

      

      set serveroutput on

      

      DECLARE

       s VARCHAR2(4000);

       x PLS_INTEGER;

       y PLS_INTEGER;

      

       id           PLS_INTEGER := 1;

       lastone      BOOLEAN := FALSE;

       xname_size   PLS_INTEGER;

       xvalue_start PLS_INTEGER;

       xvalue_size  PLS_INTEGER;

      BEGIN

        SELECT jp() INTO s;

      

        x := 2; /* starting column in s, to ignore the opening { */

        y := 1; /* column where comma separator is found. */

      

        LOOP

          y := INSTR(s, ',', x, 1);

          IF (y < 1) THEN

            y := INSTR(s, '}', x, 1);

            lastone := true;

          END IF;

      

          dbms_output.put_line(SUBSTR(s, x, y-x));

      

          xname_size := INSTR(s, '=', x, 1) - x;

          xvalue_start := x + xname_size + 1;

          xvalue_size := INSTR(s, ',', xvalue_start, 1) - xvalue_start;

      

          IF (lastone) THEN

            xvalue_size := INSTR(s, '}', xvalue_start, 1) - xvalue_start;

          END IF;

      

          IF (xvalue_size > 0) THEN

            INSERT INTO java_properties

            (rid, name, value)

            VALUES (

            id, SUBSTR(s, x, xname_size), SUBSTR(s, xvalue_start, xvalue_size));

          ELSE

            INSERT INTO java_properties (id, name)

            (rid, name)

            VALUES

            (id, SUBSTR(s, x, xname_size));

          END IF;

          id := id + 1;

      

          IF (lastone) THEN

            EXIT;

          END IF;

      

          x := y + 2;

        END LOOP;

      END;

      /

      

      
      -- =============================================

      -- A mystery...

      -- The property 'user.region=US' disappeared.

      -- It was there yesterday!

      -- Is it on your system? Today? Tomorrow?

      -- =============================================

      

      SELECT * FROM java_properties ORDER BY name;

      

      SELECT * FROM java_properties WHERE value IS NULL ORDER BY name;

      

      
      -- =============================================

      -- Revoke java PropertyPermission...

      -- =============================================

      

      conn sys@pdbdev as sysdba

      

      CALL dbms_java.revoke_permission('UWCLASS', 'SYS:java.util.PropertyPermission', '*', 'read,write');

      

      set linesize 121

      col grantee format a10

      col type_schema format a5

      col type_name format a30

      col name format a20

      col action format a20

      col enabled format a10

      

      SELECT * FROM dba_java_policy

      WHERE grantee = 'UWCLASS';

      

      SELECT COUNT(*) FROM dba_java_policy;

      

      SELECT * FROM dba_java_policy;

      

      
      -- =============================================

      -- Back to our user...

      -- =============================================

      

      conn uwclass/uwclass@pdbdev

      

      set pagesize 30

      set linesize 121

      col name format a40

      col value format a60

      col id format 999

      set serveroutput on

      ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';

      

      
      -- =============================================

      -- The following should fail because of revoked permission...

      -- =============================================

      

      SELECT jp();

      

      
      -- =============================================

      -- But we still have our java_properties table...

      -- =============================================

      

      SELECT * FROM java_properties;

      

      -- =============================================

      -- Java & Oracle predefined permissions are described:

      -- https://youngcow.net/doc/oracle10g/java.102/b14187/chnine.htm

      -- =============================================

GRANT_POLICY_PERMISSION

A specialized version of GRANT_PERMISSION

Overload 1 dbms_java.grant_policy_permission( grantee IN VARCHAR2, permission_schema IN VARCHAR2, permission_type IN VARCHAR2, permission_name IN VARCHAR2, key OUT NUMBER);

TBD

Overload 2 dbms_java.grant_policy_permission( grantee IN VARCHAR2, permission_schema IN VARCHAR2, permission_type IN VARCHAR2, permission_name IN VARCHAR2);

TBD

HOTLOAD_MODULE (new 23ai)

Undocumented

Overload 1 dbms_java.hotload_module(module IN VARCHAR2);

TBD

Overload 2 dbms_java.hotload_module( module IN VARCHAR2, schema IN VARCHAR2);

TBD

IMPORT_RAW_CHUNK (new 23ai)

Undocumented dbms_java.import_raw_chunk( chunk IN RAW, length IN NUMBER) RETURN NUMBER;

TBD

IMPORT_TEXT_CHUNK (new 23ai)

Undocumented dbms_java.import_text_chunk( chunk IN VARCHAR2, length IN NUMBER) RETURN NUMBER;

TBD

INITIALIZE_OUTPUT_TO_FILE (new 23ai)

Undocumented dbms_java.initialize_output_to_file( id IN VARCHAR2, path IN VARCHAR2);

TBD

INIT_BTL (new 23ai)

Undocumented dbms_java.init_btl( files_prefix IN VARCHAR2, type IN NUMBER, sample_limit IN NUMBER, exclude_java IN NUMBER) RETURN NUMBER;

TBD

JAR_DIGEST (new 23ai)

Undocumented dbms_java.jar_digest( jar_name IN VARCHAR2, schema IN VARCHAR2, algorithm IN VARCHAR2) RETURN VARCHAR2;

TBD

JAR_DIGEST_BYTES (new 23ai)

Undocumented dbms_java.jar_digest_bytes( jar_name IN VARCHAR2, schema IN VARCHAR2, algorithm IN VARCHAR2) RETURN RAW;

TBD

JAR_NAME_FROM_MODULE (new 23ai)

Undocumented dbms_java.jar_name_from_module( module IN VARCHAR2, schema IN VARCHAR2) RETURN VARCHAR2;

TBD

LOADJAVA

Loads Java classes into the database

See: ?/rdbms/admin/initsjty.sql dbms_java.loadjava(option IN VARCHAR2) AS LANGUAGE JAVA NAME 'oracle.aurora.server.tools.loadjava.LoadJavaMain.serverMain(java.lang.String)';

exec sys.dbms_java.loadjava('-v -r rdbms/jlib/sqljtype.jar');

LONGNAME (new 23ai)

Undocumented dbms_java.longname(shortname IN VARCHAR2) RETURN VARCHAR2;

TBD

NATIVE_COMPILER_OPTIONS (new 23ai)

Undocumented dbms_java.native_compiler_options RETURN compiler_option_type_table PIPELINED;

SELECT * FROM TABLE(dbms_java.native_compiler_options);

      

      OPTION_LINE

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

      Option 'exclude'

      Exclude method from compilation.

      Format:

      'exclude', 'java.util.Hashtable'

      'exclude', 'java.util.Hashtable.get(java.lang.Object)'

      'exclude', 'java.util.Hashtable.get(java.lang.Object) return 
      java.lang.Object'

      'exclude', 'java/util/Hashtable.get(Ljava/lang/Object;)Ljava/lang/Object;

      'exclude', 'java.util.HashMap'

      

      Java Virtual-Machine Specification style method signatures,

      javap-style method signatures and call-spec style method signatures are all accepted.

      If no method name/signature is given, all methods in the indicated class

      will be excluded

      

      

      Option 'asyncPollLevel'

      Level of polling used by generated code.

      Asycynchronous events (such as Ctrl-C interrupt) are polled for in

      compiled code. This option specifies how compiled-code should poll
      for these events.

      Values:

      SysEventsOnly - Poll on System-events (such as GC) only. This is default.

      MethodEntry - Poll on each method-entry.

      MethodEntryAndBranches - Poll on each method-entry and backwards-branch.

      Format:

      'asyncPollLevel', '<value>'

      

      ...

      

      Option 'cpuFeatureFlagOverride'

      override the value of the current cpu-feature flags

      Values: [int]

      

      OPTION_LINE

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

      Format:

      'cpuFeatureFlagOverride', '<value>'

      

      

      Option 'debugDeadBeefJitFrame'

      Turn on DeadBeef option to deadbeef the Java Frame

      Values: { true, false }

      Format:

      'debugDeadBeefJitFrame', '<value>'

      

      683 rows selected.

NCOMP_STATUS_MSG (new 23ai)

Undocumented dbms_java.ncomp_status_msg RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.DbmsJava.ncompEnabledMsg() RETURN java.lang.String';

TBD

OPTION_CONTROLLER (new 23ai)

Undocumented dbms_java.option_controller( opt IN NUMBER, action IN NUMBER) RETURN NUMBER AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.Compiler.optionController(int, int) RETURN BOOLEAN';

TBD

QUERY_OUTPUT_TO_FILE (new 23ai)

Undocumented dbms_java.query_output_to_file(id IN VARCHAR2) RETURN VARCHAR2;

TBD

QUERY_OUTPUT_TO_JAVA (new 23ai)

Returns a message describing a specification created by set_output_to_java dbms_java.query_output_to_java(id IN VARCHAR2) RETURN VARCHAR2;

TBD

QUERY_OUTPUT_TO_SQL (new 23ai)

Returns a message describing a specification created by set_output_to_sql dbms_java.query_output_to_sql(id IN VARCHAR2) RETURN VARCHAR2;

TBD

QUERY_OUTPUT_TO_TRC (new 23ai)

Undocumented dbms_java.query_output_to_trc RETURN VARCHAR2;

SELECT dbms_java.query_output_to_trc;

      

      QUERY_OUTPUT_TO_TRC

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

      Output to trc is enabled

REMOVE_OUTPUT_TO_FILE (new 23ai)

Undocumented dbms_java.remove_output_to_file(id IN VARCHAR2) RETURN VARCHAR2;

TBD

REMOVE_OUTPUT_TO_JAVA (new 23ai)

Deletes a specification created by set_output_to_java. If no such specification exists, an error message is returned dbms_java.remove_output_to_java(id IN VARCHAR2) RETURN VARCHAR2;

TBD

REMOVE_OUTPUT_TO_SQL (new 23ai)

Deletes a specification created by set_output_to_sql. If no such specification exists, an error message is returned dbms_java.remove_output_to_sql(id IN VARCHAR2) RETURN VARCHAR2;

TBD

REMOVE_PROPERTY (new 23ai)

Removes any value previously set by set_property dbms_java.remove_property(name IN VARCHAR2) RETURN VARCHAR2;

TBD

RESET_COMPILER_OPTION (new 23ai)

Reset the option value and undos an action performed by set_compiler_option dbms_java.reset_compiler_option( what IN VARCHAR2, optionName IN VARCHAR2);

TBD

RESET_PROPERTY_DEFS_TABLE_FLAG

Undocumented dbms_java.reset_property_defs_table_flag;

exec dbms_java.reset_property_defs_table_flag;

      

      PL/SQL procedure successfully completed.

RESOLVER (23ai)

Undocumented dbms_java.resolver( name IN VARCHAR2, owner IN VARCHAR2, type IN VARCHAR2) RETURN VARCHAR2;

TBD

RESTRICT_PERMISSION

Restricts a permission as specified in the policy table dbms_java.grant_policy_permission( grantee IN VARCHAR2, permission_type IN VARCHAR2, permission_name IN VARCHAR2, permission_action IN VARCHAR2);

TBD

REVOKE_PERMISSION

Disables any permissions that might have been granted dbms_java.revoke_permission( grantee IN VARCHAR2, permission_type IN VARCHAR2, permission_name IN VARCHAR2, permission_action IN VARCHAR2) AS LANGUAGE JAVA NAME 'oracle.aurora.rdbms.security.PolicyTableManager.revoke( java.lang.String, java.lang.String, java.lang.String, java.lang.String)';

See GRANT_PERMISSION Demo Above

RUNJAVA (new 23ai)

A facility for running java in the OJVM server resident VM using a command line interface emulating the JDK java shell command dbms_java.runjava(runjava(cmdline IN VARCHAR2) RETURN VARCHAR2;

TBD

RUNJAVA_IN_CURRENT_SESSION (new 23ai)

Same as runjava except that it does not clear the java state remaining from the previous use of java in the session prior to executing the current command line dbms_java.runjava_in_current_session(cmdline IN VARCHAR2) RETURN VARCHAR2;

TBD

SEND_COMMAND (new 23ai)

Sends command chunks to the shell dbms_java.send_command(chunk IN LONG RAW);

TBD

SET_COMPILER_OPTION (new 23ai)

Sets the option value of the option optionName applied to what. Depending upon the characteristics of optionName it may apply to "descendants" of what as well. dbms_java.set_compiler_option( what IN VARCHAR2, optionName IN VARCHAR2, value IN VARCHAR2);

TBD

SET_EXECUTE_PRIVILEGE

Undocumented dbms_java.set_execute_privilege( object_name IN VARCHAR2, object_schema IN VARCHAR2, object_type IN VARCHAR2, grantee_name IN VARCHAR2, grant_if_nonero IN NUMBER);

TBD

SET_FIXED_IN_INSTANCE (new 23ai)

Undocumented dbms_java.set_fixed_in_instance( name IN VARCHAR2, owner IN VARCHAR2, type IN VARCHAR2, value IN NUMBER);

TBD

SET_NATIVE_COMPILER_OPTION (new 23ai)

Sets a native-compiler option to the specified value for the current schema dbms_java.set_native_compiler_option( optionName IN VARCHAR2, value IN VARCHAR2);

TBD

SET_OUTPUT

Method for controlling destination of java output dbms_java.set_output(buffersize IN NUMBER);

exec dbms_java.set_output(1000000);

      

      PL/SQL procedure successfully completed.

SET_OUTPUT_TO_FILE (new 23ai)

Defines a named output specification which constitutes a prescription to capture any output sent to the default System.out and System.err streams occurs dbms_java.set_output_to_file( id IN VARCHAR2, file_path IN VARCHAR2, allow_replace IN NUMBER DEFAULT 1, from_stdout IN NUMBER DEFAULT 1, from_stderr IN NUMBER DEFAULT 1) RETURN VARCHAR2;

TBD

SET_OUTPUT_TO_JAVA (new 23ai)

defines a named output specification which constitutes a prescription for executing a java method wheneveroutput to the default System.out and System.err streams occurs dbms_java.set_output_to_java( id IN VARCHAR2, class_name IN VARCHAR2, class_schema IN VARCHAR2, method IN VARCHAR2, bindings IN VARCHAR2, no_newline_method IN VARCHAR2 DEFAULT NULL, no_newline_bindings IN VARCHAR2 DEFAULT NULL, newline_only_method IN VARCHAR2 DEFAULT NULL, newline_only_bindings IN VARCHAR2 DEFAULT NULL, maximum_line_segment_length IN NUMBER DEFAULT 0, allow_replace IN NUMBER DEFAULT 1, from_stdout IN NUMBER DEFAULT 1, from_stderr IN NUMBER DEFAULT 1, include_newlines IN NUMBER DEFAULT 0, eager IN NUMBER DEFAULT 0, initialization_statement IN VARCHAR2 DEFAULT NULL, finalization_statement IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;

TBD

SET_OUTPUT_TO_SQL (new 23ai)

defines a named output specification which constitutes a prescription for executing a sql statement whenever
-- output to the default System.out and System.err streams occurs dbms_java.set_output_to_sql( id IN VARCHAR2, stmt IN VARCHAR2, bindings IN VARCHAR2, no_newline_stmt IN VARCHAR2 DEFAULT NULL, no_newline_bindings IN VARCHAR2 DEFAULT NULL, newline_only_stmt IN VARCHAR2 DEFAULT NULL, newline_only_bindings IN VARCHAR2 DEFAULT NULL, maximum_line_segment_length IN NUMBER DEFAULT 0, allow_replace IN NUMBER DEFAULT 1, from_stdout IN NUMBER DEFAULT 1, from_stderr IN NUMBER DEFAULT 1, include_newlines IN NUMBER DEFAULT 0, eager IN NUMBER DEFAULT 0) RETURN VARCHAR2;

TBD

SET_PERMISSION_DEBUG (new 23ai)

Sets the debugging level dbms_java.set_permission_debug(level IN NUMBER);

TBD

SET_PREFERENCE (new 23ai)

Adds a preference to the database dbms_java.set_preference( user IN VARCHAR2, type IN VARCHAR2, abspath IN VARCHAR2, key IN VARCHAR2, value IN VARCHAR2);

TBD

SET_PROPERTY (new 23ai)

Sets a value for a System property which will be used thereafter for the duration of the current RDBMS session whenever a java session is initialized dbms_java.set_property( name IN VARCHAR2, value IN VARCHAR2) RETURN VARCHAR2;

TBD

SET_RUNTIME_EXEC_CREDENTIALS

Associate all database users with the OS account identified by credential pair 'osuser'/'ospass'. The association is in effect for any user that does not have credentials

Overload 1 dbms_java.set_runtime_exec_credentials( dbuser IN VARCHAR2, osuser IN VARCHAR2, ospass IN VARCHAR2);

TBD

Overload 2 dbms_java.set_runtime_exec_credentials( osuser IN VARCHAR2, ospass IN VARCHAR2);

TBD

SET_SYSTEM_CLASS_LOADING (new 23ai)

enables (1) or disables (0) system class loading for current session dbms_java.set_system_class_loading(flag IN NUMBER);

TBD

SET_VERIFIER (new 23ai)

Enables (1) or disables (0) the byte code verifier dbms_java.set_verifier(flag IN NUMBER);

TBD

SHAREDPRIVATECLASSNAME (new 23ai)

Undocumented dbms_java.sharedprivateclassname(name IN VARCHAR2) RETURN VARCHAR2;

TBD

SHORTNAME

Returns the shorted class name dbms_java.shortname(longname IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_java.shortname('oracle/mgd/idcode/IDCodeTranslator');

      

      DBMS_JAVA.SHORT_NAME('ORACLE/MDG/IDCODE/IDCODETRANSLATOR')

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

      oracle/mgd/idcode/IDCodeTranslator

SHOW_PROPERTY (new 23ai)

Establishes a value for a System property which will be used thereafter for the duration of the current RDBMS session whenever a java session is initialized dbms_java.show_property( name IN VARCHAR2, value IN VARCHAR2) RETURN VARCHAR2;

TBD

START_BTL

Undocumented dbms_java.start_btl;

exec dbms_java.start_btl;

      

      PL/SQL procedure successfully completed.

START_EXPORT

Undocumented dbms_java.start_export( short_name IN VARCHAR2, schema IN VARCHAR2, flags IN NUMBER, type IN NUMBER, properties OUT NUMBER, raw_chunk_count OUT NUMBER, total_raw_byte_count OUT NUMBER, text_chunk_count OUT NUMBER, total_text_byte_count OUT NUMBER) RETURN NUMBER;

TBD

START_IMPORT (new 23ai)

Undocumented dbms_java.start_import( long_name IN VARCHAR2, flags IN NUMBER, type IN NUMBER, properties IN NUMBER, raw_chunk_count IN NUMBER, total_raw_byte_count IN NUMBER, text_chunk_count IN NUMBER) RETURN NUMBER;

TBD

START_JMX_AGENT (new 23ai)

Start an agent activating OJVM JMX server and remote listener dbms_java.start_jmx_agent( port IN VARCHAR2 DEFAULT NULL, ssl IN VARCHAR2 DEFAULT NULL, auth IN VARCHAR2 DEFAULT NULL);

TBD

STOPBTL

Undocumented dbms_java.stop_btl;

exec dbms_java.stop_btl;

      

      PL/SQL procedure successfully completed.

TERMINATE_BTL

Undocumented dbms_java.terminate_btl;

exec dbms_java.terminate_btl;

      

      PL/SQL procedure successfully completed.

UNCOMPILE_CLASS (new 23ai)

If the class does not exist an ORA-29532 (Uncaught Java exception) will occur dbms_java.uncompile_class( classname IN VARCHAR2, permanentp IN NUMBER DEFAULT 0) RETURN NUMBER;

TBD

UNCOMPILE_METHOD (new 23ai)

Uncompiles the method specified by the name and Java type signature defined by the class identified by classname in the current schema. dbms_java.uncompile_method( classname IN VARCHAR2, methodname IN VARCHAR2, methodsig IN VARCHAR2, permanentp IN NUMBER DEFAULT 0) RETURN NUMBER;

TBD

UNHOTLOAD_MODULE (new 23ai)

Undocumented

Overload 1 dbms_java.unhotload_module(module IN VARCHAR2);

TBD

Overload 2 dbms_java.unhotload_module( module IN VARCHAR2, schema IN VARCHAR2);

TBD

UNSET_NATIVE_COMPILER_OPTION (new 23ai)

unsets a native-compiler option given by the tuple [optionName, value] dbms_java.unset_native_compiler_option( ptionName IN VARCHAR2, value IN VARCHAR2);

TBD