Oracle PL/SQL for DBAs

Name

ENCRYPT

Synopsis

This program produces encrypted values from input values. 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 encrypted value as a RAW datatype.

Parameter name	Datatype	Description
src	RAW	Value to be encrypted. This value may be of any length.
typ	BINARY_INTEGER	Combines the encryption algorithm, padding method, and chaining method.
key	RAW	Encryption key.
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

Encrypts LOBs. To encrypt non-LOB values, use the function version of ENCRYPT. This version accepts four input parameters and returns the encrypted value as a RAW datatype.

Parameter name	Datatype	Description
dst	BLOB	OUT parameter; the encrypted value is passed back to the user in this parameter.
src	BLOB	BLOB value or resource locator to be encrypted.
typ	BINARY_INTEGER	Combines the encryption algorithm, padding method, and chaining method.
key	RAW	Encryption key.
iv	RAW	Initialization vector. This value is added to the input value to reduce the repetition of encrypted values. It is optional.

Procedure—Version 2

Identical to the first procedure version, except that it is used to encrypt CLOB data.

Parameter name ...