Oracle | DBMS_CRYPTO

Oracle DBMS_CRYPTO_INTERNAL Version 23c

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

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;

      /

      *

      ERROR at line 1:

      ORA-28365: wallet is not open

      ORA-06512: at "SYS.DBMS_CRYPTO_INTERNAL", line 203

      ORA-06512: at "SYS.DBMS_CRYPTO_INTERNAL", line 243

      ORA-06512: at line 7

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.