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
The source file states: "This package defines the API to java$jvm$rjbc and related routines."
Another source identifies it as: "JVM utility for working with LOBs (initdbj)."
jvmrjbc.putPath(
sessid IN VARCHAR2,
pathname IN VARCHAR2);
-- return a list of tables with BLOB columns
SELECT dtc.table_name, dtc.column_name
FROM dba_tab_cols dtc, dba_tables dt
WHERE dtc.owner = 'SYS'
AND dtc.owner = dt.owner
AND dtc.table_name = dt.table_name
AND dt.num_rows > 0
AND dtc.data_type = 'BLOB'
ORDER BY 1;
-- find one of the tables with a BLOB column that contains a BLOB for use below
SELECT dbms_lob.getLength(awlob)
FROM aw$awcreate
WHERE dbms_lob.getLength(awlob) > 0;