Oracle 12c DBMS_XS

Oracle DBMS_XS_SIDP Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

Real Application Security

AUTHID

CURRENT_USER

Dependencies

DBMS_RXS_LIB

Documented

First Available

Not Known

Security Model

Owned by SYS with EXECUTE granted to XS_SESSION_ADMIN

Source

{ORACLE_HOME}/rdbms/admin/prvtkzrxh.plb

Subprograms

DODHEXCHANGE

FIXDHKEYSIZE

DODHEXCHANGE

Undocumented

dbms_xs_sidp.doDHExchange(
mpkey IN VARCHAR2
mtid IN RAW
spkey OUT VARCHAR2
sskeyhOUT RAW);

DECLARE
v VARCHAR2(32767);
r RAW(64);
BEGIN
dbms_xs_sidp.doDHExchange('Test', utl_raw.cast_to_raw('Test'), v, r);
dbms_output.put_line(v);
dbms_output.put_line(r);
END;
/

FIXDHKEYSIZE

Undocumented

dbms_xs_sidp.fixDHKeySize(
mkeysz    IN BINARY_INTEGER
skeysz    OUT BINARY_INTEGER
disp_only OUT BINARY_INTEGER
nlscs     OUT BINARY_INTEGER);

DECLARE
s PLS_INTEGER;
d PLS_INTEGER;
n PLS_INTEGER;
BEGIN
dbms_xs_sidp.fixDHKeySize(32, s, d, n);
dbms_output.put_line(TO_CHAR(s));
dbms_output.put_line(TO_CHAR(d));
dbms_output.put_line(TO_CHAR(n));
END;
/