Oracle PL/SQL for DBAs

Name

DES3DECRYPT

Synopsis

This program decrypts an encrypted data using the DES3 algorithm. As with its encryption sister program DES3ENCRYPT, it is overloaded as a function and a procedure, and is further overloaded for different datatypes.

Procedure—Version 1

Accepts four input parameters and returns the decrypted value in the OUT parameter.

Parameter name	Datatype	Description
input_string	VARCHAR2	Encrypted string to be decrypted.
key_string	VARCHAR2	Encryption key; this must be the same one used during encryption.
decrypted_string	VARCHAR2	The only OUT parameter; the decrypted value is placed here.
which	BINARY_INTEGER	Number of passes for Triple DES algorithm: 1 for two-pass, 2 for three-pass. The default is 1 (two-pass).
iv_string	VARCHAR2	Initialization vector. This value is added to the input value to reduce the repetition of encrypted values. It is optional, but if an IV was used during encryption, it must be specified for decryption as well.

Procedure—Version 2

Identical to the first version, except that it accepts inputs in RAW.

Parameter name	Datatype	Description
input	RAW	Encrypted value to be decrypted.
key	RAW	Encryption key that was used during encryption.
decrypted_data	RAW	The only OUT parameter; the decrypted value is placed here.
which	BINARY_INTEGER	Number of passes for Triple DES algorithm: 1 for two-pass, 2 for three-pass. The default is 1 (two-pass).
iv	RAW	Initialization vector. This value is added to the input value to reduce ...