Oracle | DBMS_CRYPTO

Oracle DBMS_CRYPTO_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

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.

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.