Oracle | JVMRJBC

Oracle JVMRJBC Version 21c

General Information

Library Note

Morgan's Library Page Header

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 Oracle says "This package defines the API to java$jvm$rjbc and related routines."

Another source identifies it as: "JVM utility for working with LOBs (initdbj)."

Likely both are correct.

AUTHID DEFINER

Dependencies

BMS_CRYPTO	DBMS_PIPE	JVMRJBCINV
DBMS_LOB	JAVA$JVM$RJBC

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/initdbj.sql

Subprograms

DONE	GETPATH	PUTLOB
GETLOB	INIT	PUTPATH

DONE

Closes a session identifier jvmrjbc.done(sessid IN VARCHAR2);

DECLARE

       inVal dbms_id := 

      'ORA$PIPE$00BA74A4000171CBDF0007BA4C499FED03B1D4B239C9F61B9E92AA2F30692AD1B6AFE0FDC2FFF01945';

      BEGIN

        jvmrjbc.done(inVal);

      END;

      /

      

      PL/SQL procedure successfully completed.

GETLOB

Returns the BLOB loaded with PUTLOB jvmrjbc.getLOB(sessid IN VARCHAR2) RETURN BLOB;

DECLARE

       sid    dbms_id := 

      'ORA$PIPE$00BA74A400012BD2510A70A92DFD2F8F623A60BFC19C1A83339E785F3386AE385F27D8F08D3FAAEB00';

       retVal BLOB;

      BEGIN

        retVal := jvmrjbc.getLOB(sid);

        dbms_output.put_line(TO_CHAR(dbms_lob.getLength(retVal)));

      END;

      /

      0

      

      PL/SQL procedure successfully completed.

GETPATH

Returns the path loaded with PUTPATH jvmrjbc.getPath(sessid IN VARCHAR2) RETURN VARCHAR2;

DECLARE

       sid    dbms_id := 

      'ORA$PIPE$00BA74A400012BD2510A70A92DFD2F8F623A60BFC19C1A83339E785F3386AE385F27D8F08D3FAAEB00';

       retVal dbms_id;

      BEGIN

        retVal := jvmrjbc.getPath(sid);

        dbms_output.put_line(retVal);

      END;

      /

      

      PL/SQL procedure successfully completed.

INIT

Initialize a session identifier jvmrjbc.init RETURN VARCHAR2;

DECLARE

       retVal dbms_id;

      BEGIN

        retVal := jvmrjbc.init;

        dbms_output.put_line(retVal);

      END;

      /

      ORA$PIPE$00969B680001572C887EF78338F52BD26CB7487364EEC85603859958A96BD913AB17695919E406D030

      

      PL/SQL procedure successfully completed.

PUBLOB

Loads the BLOB returned by PUTLOB jvmrjbc.putLOB( sessid IN VARCHAR2, l IN BLOB);

TBD

PUTPATH

Loads the path returned by PUTPATH jvmrjbc.putPath( sessid IN VARCHAR2, pathname IN VARCHAR2);

TBD