Oracle 12c DBMS_JAVA

Oracle DBMS_JAVA_MISC Version 12.1.0.1

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Purpose

Undocumented

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

DBA_JAVA_CLASSES	DBMS_JAVA_TEST	DBMS_STANDARD
DBA_JAVA_METHODS	DBMS_PIPE	JVMRJBC
DBMS_JAVA

Documented

First Available

12.1.0

Security Model

Owned by SYS with no privileges granted

Source

{ORACLE_HOME}/rdbms/admin/initdbj.html

Subprograms

DEPLOY_COPY	JAR_STATUS	RJBC_REQUEST
DEPLOY_INVOKE	RJBC_DONE	RJBC_RESPOND
DEPLOY_OPEN	RJBC_INIT	RUNJAVA
DROP_JAR	RJBC_NORMALIZE	RUNJAVA_IN_CURRENT_SESSION
FINISH_LOADING_JAR	RJBC_OUTPUT	START_LOADING_JAR
HANDLEMD5

DEPLOY_COPY

Copies a chunk out of the BLOB

dbms_java_misc.deploy_copy(b IN BLOB)
AS LANGIAGE JAVA
NAME 'oracle.aurora.server.tools.loadjava.Deploy.copy(oracle.sql.BLOB)';

TBD

DEPLOY_INVOKE

Deployed class invoker

dbms_java_misc.deploy_invoke(
schema IN VARCHAR,
classname IN VARCHAR)
RETURN VARCHAR2
AS LANGUAGE JAVA
NAME 'oracle.aurora.server.tools.loadjava.Deploy.invoke(java.lang.String, java.lang.String)
RETURN java.lang.String';

TBD

DEPLOY_OPEN

Starts the actions of copying a file to the server.
b is used repeatedly to copy chuncks.

dbms_java_misc.deploy_open(
filename IN VARCHAR,
b OUT BLOB)
AS LANGUAGE JAVA
NAME 'oracle.aurora.server.tools.loadjava.Deploy.open (java.lang.String, oracle.sql.BLOB[])';

TBD

DROP_JAR

Undocumented

dbms_java_misc.drop_jar(
name IN VARCHAR2,
schema IN VARCHAR2,
msg OUT VARCHAR2)
RETURN NUMBER
AS LANGUAGE JAVA
NAME 'oracle.aurora.rdbms.DbmsJava.dropJar(java.lang.String, java.lang.String, java.lang.String[]) RETURN INT';

TBD

FINISH_LOADING_JAR

Finish JAR Loading

finish_loading_jar(
flags IN NUMBER,
msg OUT VARCHAR2)
RETURN NUMBER
AS LANGUAGE JAVA
NAME 'oracle.aurora.rdbms.DbmsJava.finishLoadingJar(int, java.lang.String[]) RETURN INT';

TBD

HANDLEMD5

Accesses information about schema objects that
are needed by loadjava

Overload 1

dbms_java_misc.handleMd5(
s IN VARCHAR2,
name IN VARCHAR2,
type IN NUMBER)
RETURN RAW
AS LANGUAGE JAVA
NAME 'oracle.aurora.server.tools.loadjava.HandleMd5.get(java.lang.String, java.lang.String,int) RETURN oracle.sql.RAW';

TBD

Variant that looks in current schema

Overload 2

handleMd5(name VARCHAR2,
type IN NUMBER)
RETURN IN RAW
AS LANGUAGE JAVA
NAME 'oracle.aurora.server.tools.loadjava.HandleMd5.get(java.lang.String,int)
RETURN oracle.sql.RAW';

TBD

JAR_STATUS

Returns the status of a JAR being loaded

dbms_java_misc.jar_status(
name IN VARCHAR2,
schema IN VARCHAR2,
msg OUT VARCHAR2)
RETURN NUMBER
AS LANGUAGE JAVA
NAME 'oracle.aurora.rdbms.DbmsJava.jarStatus(java.lang.String, java.lang.String, java.lang.String[]) RETURN INT';

TBD

RJBC_DONE

Called from thje client to shutdown the back channel

dbms_java_misc.rjbc_done(id IN VARCHAR2 := NULL);

exec dbms_java_misc.rjbc_done;

RJBC_INIT

setup back channel, return id that identifies it. Called prior to runjava in the same session as runjava will run in. flags non zero means dont use back channel for file content this corresponds to the ojvmjava runjava mode server_file_system

dbms_java_misc.rjbc_init(flags IN NUMBER) RETURN VARCHAR2;

DECLARE
x VARCHAR2(256);
BEGIN
x := dbms_java_misc.rjbc_init(8192);
dbms_output.put_line(x);
END;
/

RJBC_NORMALIZE

Called from runjava to ask for the normalized, absolute pathname on the client filesystem of the file identified by the input argument pathname

dbms_java_misc.rjbc_normalize(
pathname IN VARCHAR2,
rtype IN NUMBER,
normalized_pathname OUT VARCHAR2)
RETURN NUMBER;

TBD

RJBC_OUTPUT

Set_output_to_sql entrypoint used by runjava to pass output back to the client. Puts text in the java$jvm$rjbc row then waits for client response.

dbms_java_misc.rjbc_output(
text IN VARCHAR2,
nl IN NUMBER);

TBD

RJBC_REQUEST

Called from runjava to ask for contents or directoriness of file identified by pathname on the client filesystem

dbms_java_misc.rjbc_request(
pathname IN VARCHAR2,
rtype IN NUMBER,
lob OUT BLOB)
RETURN NUMBER;

TBD

RJBC_RESPOND

Back channel entrypoint rjbc_respond. Called in loop by back channel client thread to respond to requests queued by rjbc_request, rjbc_normalize and rjbc_output. Status argument indicates result of processing the previous request.

dbms_java_misc.rjbc_respond(
sid    IN     VARCHAR2,
status IN     NUMBER,
p      IN OUT VARCHAR2,
l      IN     BLOB)
RETURN NUMBER;

TBD

RUNJAVA

Support for dbms_java.runjava

dbms_java_misc.runjava(cmdline IN VARCHAR2) RETURN VARCHAR2;

TBD

RUNJAVA_IN_CURRENT_SESSION

Support for dbms_java.runjava

dbms_java_misc.runjava_in_current_session(cmdline IN VARCHAR2) RETURN VARCHAR2;

TBD

START_LOADING_JAR

JAR loading

dbms_java_misc.start_loading_jar(
name    IN VARCHAR2,
schema IN VARCHAR2,
path    IN VARCHAR2,
flags   IN NUMBER,
content IN BLOB,
msg     OUT VARCHAR2)
RETURN NUMBER
AS LANGUAGE JAVA
NAME 'oracle.aurora.rdbms.DbmsJava.startLoadingJar(java.lang.String, java.lang.String, java.lang.String, int, oracle.sql.BLOB, java.lang.String[]) RETURN INT';

TBD