Oracle DBMS_PICKLER Demos

Oracle DBMS_PICKLER Version 11.2.0.3

General Information

Purpose

Undocumented

Acronyms

TDS: Type Descriptor Source

AUTHID

DEFINER

Dependencies

DBMS_PICKLER_LIB

PRIVATE_JDBC

First Available

Security Model

Owned by SYS with EXECUTE granted to PUBLIC

Source

{ORACLE_HOME}/rdbms/admin/prvtpckl.plb

Subprograms

Undocumented

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;
/

GET_TYPE_SHAPE

Undocumented

Overload 1

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;

DECLARE
toid RAW(128);
vers PLS_INTEGER;
tdsval LONG RAW;
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: ' || tdsval);
dbms_output.put_line('LDS: ' || ldsval);
END;
/

Overload 2

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;
/

UPDATE_THROUGH_REF

Undocumented

dbms_pickler.update_through_ref(
prf     IN RAW,
version IN BINARY_INTEGER,
toid    IN RAW,
image   IN LONG RAW);
RETURN BINARY_INTEGER;

TBD