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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.