Previous	Next		Contents	Index	Glossary

The notification mailer utility API can be used to encode data in a binary large object (BLOB) to base64. This API is defined in a PL/SQL package called WF_MAIL_UTIL.

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)

See Also

Standard APIs for "PL/SQL" Documents, Oracle Workflow Developer's Guide

Copyright © 2003 Oracle Corporation.
All rights reserved.