Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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;