Previous	Next		Contents	Index	Glossary

Note: This package is only available if your database version is Oracle9i Database or higher. The Oracle8i Database does not support base64 encoding.

procedure EncodeBLOB

    (pIDoc in blob,

     pODoc in out nocopy clob);

Description

Encodes the specified BLOB to base64 and returns the encoded data as a character large object (CLOB). You can use this procedure to store a BLOB in a PL/SQL CLOB document to be included in a notification message.

Note: This API is only available if your database version is Oracle9i Database or higher. The Oracle8i Database does not support base64 encoding.

Arguments (input)

pIDoc	The BLOB to encode.
pODoc	The CLOB in which the encoded data should be stored.

See Also