Oracle PL/SQL for DBAs

Name

DECRYPT

Synopsis

This program decrypts encrypted values. Like ENCRYPT, the program is overloaded as a function and two procedures, and is further overloaded for different datatypes.

Function Version

Accepts four input parameters and returns the decrypted value as a RAW datatype.

Parameter name	Datatype	Description
src	RAW	Encrypted value to be decrypted.
typ	BINARY_INTEGER	Combines the encryption algorithm, padding method and chaining method. It must be the same one used during encryption.
key	RAW	Encryption key; must be the same one used during encryption.
iv	RAW	Initialization vector. This value is added to the input value to reduce the repetition of encrypted values. This parameter must be specified if it was used during encryption, and it must be the same value used for encryption.

Procedure—Version 1

Decrypts encrypted LOBs. To decrypt encrypted non-LOB values, use the function variant of DECRYPT instead. This version accepts four input parameters and returns the decrypted value in the BLOB datatype.

Parameter name	Datatype	Description
dst	BLOB	Decrypted value is placed here.
src	BLOB	Encrypted BLOB value or resource locator to be decrypted.
typ	BINARY_INTEGER	Combines the encryption algorithm, padding method, and chaining method. It must be the same one used during encryption.
key	RAW	Encryption key; must be the same one used during encryption.
iv	RAW	Initialization vector. This value is added to the input value to reduce the repetition of encrypted ...