Notification System APIs

Notification Mailer Utility API

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.

EncodeBLOB

PL/SQL Syntax

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.

Arguments (input)

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