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 ...

Get Oracle PL/SQL for DBAs now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.