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 12.1.0.1 to 12.1.0.2. 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.

Interested in Oracle GoldenGate? Check out the IGGOUG,
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 No
First Available 12.1.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/initdbj.html
Subprograms
 
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

Related Topics
DBMS_JAVA
DBMS_JAVA_DUMP
DBMS_JAVA_TEST
Packages

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