Oracle PL/SQL for DBAs

Name

DES3ENCRYPT

Synopsis

This program is used to encrypt input data using the DES3 algorithm. 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 encrypted value in the OUT parameter.

Parameter name	Datatype	Description
input_string	VARCHAR2	Input string to be encrypted. Its length must be a multiple of eight.
key_string	VARCHAR2	Encryption key. Its length must be a multiple of eight.
encrypted_string	VARCHAR2	The only OUT parameter; the encrypted 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. If used, then the combined length of the input string and the IV must be a multiple of eight.

Procedure—Version 2

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

Parameter Name	Datatype	Description
input	RAW	Input string to be encrypted.
key	RAW	Encryption key.
encrypted	RAW	The only OUT parameter; the encrypted 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 the repetition of encrypted values. It is optional. ...