Oracle | DBMS_CRYPTO

Oracle DBMS_CRYPTO_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Undocumented Support Package for DBMS_CRYPTO

AUTHID DEFINER

Dependencies

CRYPTO_INTERNAL_LIB

Documented No

Exceptions

Error Code	Reason
ORA-28365	wallet is not open

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 RAW) RETURN NUMBER;

SELECT object_id

      FROM dba_objects

      WHERE object_type = 'TYPE'

      AND rownum < 11

      ORDER BY 1;

      

      DECLARE

       objNum        NUMBER := 1699;

       intCol        NUMBER := 1;

       encryptMinVal RAW(32767) := utl_raw.cast_to_raw('ABC');

       retVal        NUMBER;

      BEGIN

        retVal := dbms_crypto_internal.statsDecryptNum(objNum, intCol, encryptMinVal);

        dbms_output.put_line(retVal);

      END;

      /

      *

      ORA-28365: wallet is not open

STATSDECRYPTRAW

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

TBD

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.