Oracle 10g encryption package DBMS_CRYPTO

Oracle DBMS_CRYPTO

Version 10.2:

　

General Information
Source	{ORACLE_HOME}/rdbms/admin/dbmsobtk. SQL
Algorithm Constants	Name Data Type Value Hash Functions HASH_MD4 (128 bit hash) PLS_INTEGER 1 Hash_md5. (128-bit hash) PLS_INTEGER 2 HASH_SH1 (160 bit hash) PLS_INTEGER 3 MAC Functions HMAC_MD5 (128 bit hash) PLS_INTEGER 1 HMAC_SH1 (160 bit hash) PLS_INTEGER 2 Block Cipher Algorithms ENCRYPT_DES (56 bit) PLS_INTEGER 1; -- 0x0001 ENCRYPT_3DES_2KEY (128 bit) PLS_INTEGER 2; -- 0x0002 ENCRYPT_3DES PLS_INTEGER 3; -- 0x0003 ENCRYPT_AES128 (128 bit) PLS_INTEGER 6; -- 0x0006 ENCRYPT_AES192 (192 bit) PLS_INTEGER 7; -- 0x0007 ENCRYPT_AES256 (256 bit) PLS_INTEGER 8; -- 0x0008 ENCRYPT_RC4 (Stream Cipher) PLS_INTEGER 129; -- 0x0081 Block Cipher Chaining Modifiers CHAIN_CBC (Cipher Block Chaining) PLS_INTEGER 256; -- 0x0100 CHAIN_CFB (Cipher Feedback) PLS_INTEGER 512; -- 0x0200 CHAIN_ECB (Electronic cookbook) PLS_INTEGER 768; -- 0x0300 CHAIN_OFB (Output Feedback) PLS_INTEGER 1024; -- 0x0400 Block Cipher Padding Modifiers PAD_PKCS5 (Complies with PKCS #5) PLS_INTEGER 4096; -- 0x1000 PAD_NONE (No Dadding) PLS_INTEGER 8192; -- 0x2000 PAD_ZERO (Pad with Zeros) PLS_INTEGER 12288; -- 0x3000 Block Ciphers Suites DES_CBC_PKCS5 PLS_INTEGER ENCRYPT_DES + CHAIN_CBC + PAD_PKCS5; DES3_CBC_PKCS5 PLS_INTEGER ENCRYPT_3DES + CHAIN_CBC + PAD_PKCS5;
Dependencies	DBMS_CRYPTO_FFI DECRYPTBYTES ENCRYPTBYTES DECRYPT ENCRYPT UTL_RAW
Exceptions	Error Code Reason 28827 The specified cipher suite is not defined 28829 No value has been specified for the cipher suite to be used 28233 Source data was previusly encrypted 28234 DES: Specified key size too short. DES keys must be at least 8 bytes (64 bits ). AES: Specified key size is not supported. AES keys must be 128,192, or 256 bits 28239 The encryption key has not been specified or contains a NULL value
DECRYPT
Decrypt crypt text data using stream or block cipher with user supplied key and optional iv Overload 1	Dbms_crypto.decrypt (src in raw, typ IN PLS_INTEGER, key in raw, Iv in raw default null) return raw;
	See Encrypt Overload 1 demo
Overload 2	Dbms_crypto.decrypt (dst in out nocopy blob, src in blob, Typ IN PLS_INTEGER, key in raw, iv in raw default null );
Overload 3	Dbms_crypto.decrypt (dst in out nocopy clob character set ANY_CS, Src in blob, typ IN PLS_INTEGER, key in raw, Iv in raw default null );
ENCRYPT
Encrypt plain text data using stream or block cipher with user supplied key and optional iv Overload 1	Dbms_crypto.encrypt (src in raw, typ IN PLS_INTEGER, key in raw, Iv in raw default null) return raw;
	Set serveroutput on DECLARE L_credit_card_no VARCHAR2 (19): = '2017-5678-9012-3456 '; L_ccn_raw RAW (128): = utl_raw.cast_to_raw (l_credit_card_no ); Rochelle key RAW (128): = utl_raw.cast_to_raw ('abcdefgh '); Rochelle encrypted_raw RAW (2048 ); Rochelle decrypted_raw RAW (2048 ); BEGIN Dbms_output.put_line ('original: '| l_credit_card_no ); L_encrypted_raw: = dbms_crypto.encrypt (l_ccn_raw, Dbms_crypto.des_cbc_pkcs5, l_key ); Dbms_output.put_line ('encryption: '| RAWTOHEX (utl_raw.cast_to_raw (l_encrypted_raw ))); L_decrypted_raw: = dbms_crypto.decrypt (src => l_encrypted_raw, Typ => dbms_crypto.des_cbc_pkcs5, key => l_key ); Dbms_output.put_line ('crypted: '| Utl_raw.cast_to_varchar2 (l_decrypted_raw )); END; /
	Set serveroutput on DECLARE Enc_val RAW (1, 2000 ); Rochelle key RAW (2000 ); Rochelle key_len NUMBER: = 128/8; -- convert bits to bytes Rochelle mod NUMBER: = dbms_crypto.ENCRYPT_AES128 + Dbms_crypto.CHAIN_CBC + dbms_crypto.PAD_PKCS5; BEGIN Rochelle key: = dbms_crypto.randombytes (l_key_len ); Enc_val: = dbms_crypto.encrypt ( Utl_i18n.string_to_raw ('2017-5678-9012-3456', 'al32utf8 '), Rochelle mod, Rochelle key ); Dbms_output.put_line (enc_val ); END; /
Overload 2	Dbms_crypto.encrypt (dst in out nocopy blob, src in blob, Typ IN PLS_INTEGER, key in raw, iv in raw default null );
Overload 3	Dbms_crypto.encrypt (dst in out nocopy blob, Src in clob character set ANY_CS, typ IN PLS_INTEGER, key in raw, iv in raw default null );
Dbms_crypto.encrypt (UTL_RAW.CAST_TO_RAW (CONVERT ('xxx', 'al32utf8'), typ, key );
HASH
Hash source data by cryptographic hash type Overload 1	Dbms_crypto.hash (src in raw, typ IN PLS_INTEGER) return raw;
Overload 2	Dbms_crypto.hash (src in blob, typ IN PLS_INTEGER) return raw;
Overload 3	Dbms_crypto.hash (src in clob character set ANY_CS, Typ IN PLS_INTEGER) return raw;
MAC
Message Authentication Code algorithms provide keyed message protection Overload 1	Dbms_crypto.mac (src in raw, typ IN PLS_INTEGER, key in raw) Return raw;
Overload 2	Dbms_crypto.mac (src in blob, typ IN PLS_INTEGER, key in raw) Return raw;
Overload 3	Dbms_crypto.mac (src in clob character set ANY_CS, Typ IN PLS_INTEGER, key in raw) return raw;
RANDOMBYTES
Returns a raw value containing a pseudo-random sequence of bytes	Dbms_crypto.randomnytes (number_bytes PLS_INTEGER) return raw;
	SELECT dbms_crypto.randombytes (1) FROM dual; Select length (dbms_crypto.randombytes (1) FROM dual; SELECT dbms_crypto.randombytes (28) FROM dual; Select length (dbms_crypto.randombytes (28) FROM dual; SELECT dbms_crypto.randombytes (64) FROM dual; Select length (dbms_crypto.randombytes (64) FROM dual;
RANDOMINTEGER
Returns a random BINARY_INTEGER	Dbms_crypto.randominteger return number;
	SELECT dbms_crypto.randominteger FROM dual;
RANDOMNUMBER
Returns a random Oracle Number	Dbms_crypto.randomnumber return number;
	SELECT dbms_crypto.randomnumber FROM dual;