ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Support for loadjava, calling runjava from ojvmjava
jvmrjbcinv.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';
jvmrjbcinv.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';
Acesses information about schema objects that is required by loadjava
Overload 1
jvmrjbcinv.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
jvmrjbcinv.handleMD5(
name IN VARCHAR2,
type IN NUMBER)
RETURN RAW
AS language java name
'oracle.aurora.server.tools.loadjava.HandleMd5.get
(java.lang.String,int) RETURN oracle.sql.RAW';
jvmrjbcinv.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';
-- after 5 minutes it appears that this hangs
-- confirmed by an attempted shutdown immediate that also appeared to hang
-- finally resolved with a shutdown abort and a restart
Called from runjava to ask for the normalized, absolute pathname on the client filesystem of the file identified by the input argument pathname. Puts pathname in the java$jvm$rjbc row then waits for a client response
jvmrjbcinv.rjbc_normalize(
pathname IN VARCHAR2,
rtype IN NUMBER,
normalized_pathname OUT VARCHAR2)
RETURN NUMBER;
Called from runjava to ask for contents or directoriness of file identified by pathname on the client filesystem. Puts pathname in the java$jvm$rjbc row then waits for a client response.
jvmrjbcinv.rjbc_request(
pathname IN VARCHAR2,
rtype IN NUMBER,
lob OUT BLOB)
RETURN NUMBER;
jvmrjbcinv.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';