Previous	Next		Contents	Index	Glossary

In a workflow process, you can attach documents generated by a PL/SQL procedure, which we call PL/SQL, PL/SQL CLOB, or PL/SQL BLOB documents. You attach a document to a workflow process by referencing the document in a predefined item attribute or message attribute of type Document. See: Attribute Types, To Define an Item Type or Activity Attribute and To Define a Message Attribute.

For PL/SQL, PL/SQL CLOB, or PL/SQL BLOB documents, the item or message attribute's value would be the name of the PL/SQL package and procedure used to generate the document. The PL/SQL procedure must follow an Oracle Workflow standard interface. See: Standard APIs for "PL/SQL" Documents.

For PL/SQL and PL/SQL CLOB documents that contain text or HTML, the document generated by the PL/SQL procedure can either be displayed within the text of a notification or included as an attachment. Other types of content in PL/SQL CLOB documents, as well as all PL/SQL BLOB documents, can only be included as attachments.

• In addition to text or HTML, PL/SQL CLOB documents that are included as attachments can contain PDF or RTF documents or, if your database version is Oracle9i Database or higher, binary data encoded to base64.

• PL/SQL BLOB documents that are included as attachments can contain images or other application files that are stored as binary data.

Note: An Oracle Applications Framework region can only be displayed within the message body of a notification. It cannot be included as an attachment to the notification.