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.
dbms_pickler.get_format(fdo OUT RAW) RETURN BINARY_INTEGER;
DECLARE
o PLS_INTEGER;
r RAW(128);
BEGIN
o := dbms_pickler.get_format(r);
dbms_output.put_line('Returned Value: ' || TO_CHAR(o));
dbms_output.put_line('FDO: ' || r);
END;
/
dbms_pickler.get_type_shape(
schema IN VARCHAR2,
typnam IN VARCHAR2,
typoid OUT RAW,
version OUT BINARY_INTEGER,
tds OUT LONG_RAW,
lds OUT LONG_RAW)
RETURN BINARY_INTEGER;
dbms_pickler.get_type_shape(
schema IN VARCHAR2,
typnam IN VARCHAR2,
typoid OUT RAW,
version OUT BINARY_INTEGER,
tds OUT BLOB,
lds OUT LONG_RAW)
RETURN BINARY_INTEGER;
DECLARE
toid RAW(128);
vers PLS_INTEGER;
tdsval BLOB;
ldsval LONG RAW;
retVal PLS_INTEGER;
BEGIN
retVal := dbms_pickler.get_type_shape('OE', 'PURCHASEORDER_T', toid, vers, tdsval, ldsval);
dbms_output.put_line('Returned Value: ' || TO_CHAR(retVal));
dbms_output.put_line('TOID: ' || toid);
dbms_output.put_line('Version: ' || TO_CHAR(vers));
dbms_output.put_line('TDS: Blobs Can Not Be Displayed');
dbms_output.put_line('LDS: ' || ldsval);
END;
/
Overload 3
dbms_pickler.get_type_shape(
fulltypename IN OUT VARCHAR2,
typeoid OUT RAW,
version OUT BINARY_INTEGER,
tds OUT LONG_RAW,
instantiable OUT VARCHAR2,
supertype_owner OUT VARCHAR2,
supertype_name OUT VARCHAR2,
attr_rc OUT REF CURSOR,
subtype_rc OUT REF CURSOR)
RETURN BINARY_INTEGER;
dbms_pickler.get_type_shape(
fulltypename IN OUT VARCHAR2,
typeoid OUT RAW,
version OUT BINARY_INTEGER,
tds OUT BLOB,
instantiable OUT VARCHAR2,
supertype_owner OUT VARCHAR2,
supertype_name OUT VARCHAR2,
attr_rc OUT REF CURSOR,
subtype_rc OUT REF CURSOR)
RETURN BINARY_INTEGER;