Oracle | DBMS_CRYPTO

Oracle DBMS_CRYPTO_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

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 Undocumented Support Package for DBMS_CRYPTO

AUTHID DEFINER

Dependencies

CRYPTO_INTERNAL_LIB

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtcia.plb

Subprograms

STATSDECRYPTNUM	STATSENCRYPTNUM	UPDATESENSITIVESTATS
STATSDECRYPTRAW	STATSENCRYPTRAW

STATSDECRYPTNUM

Undocumented dbms_crypto_internal.statsDecryptNum( obj_nbr IN NUMBER, col_nbr IN NUMBER, encrypted_num IN NUMBER) RETURN NUMBER;

DECLARE

       objNum        sys.wri$_optstat_histhead_history.obj#%TYPE := 8476;

       intCol        sys.wri$_optstat_histhead_history.intcol#%TYPE := 1;

       encryptMinVal sys.wri$_optstat_histhead_history.minimum_enc := 2199;

      BEGIN

        dbms_crypto_internal.statsDecryptNum(obj#, intcol#, minimum_enc);

      END;

      /

STATSDECRYPTRAW

Undocumented dbms_crypto_internal.statsDecryptRaw( obj_nbr IN NUMBER, col_nbr IN NUMBER, ciphertext IN RAW) RETURN RAW;

exec dbms_crypto_internal.statsDecryptRaw( obj#, intcol#, lowval);

STATSENCRYPTNUM

Undocumented dbms_crypto_internal.statsEncryptNum( obj_nbr IN NUMBER, col_nbr IN NUMBER, num_in_clear IN NUMBER) RETURN RAW;

TBD

STATSENCRYPTRAW

Undocumented dbms_crypto_internal.statsEncryptRaw( obj_nbr IN NUMBER, col_nbr IN NUMBER, cleartext IN RAW) RETURN RAW;

TBD

UPDATESENSITIVESTATS

Undocumented dbms_crypto_internal.updateSensitiveStats;

exec dbms_crypto_internal.updateSensitiveStats;

      

      PL/SQL procedure successfully completed.