Standard APIs for "PL/SQL" and "PL/SQL CLOB" Documents (Oracle Workflow Help)


	Previous	Next		Contents	Index	Glossary

Standard APIs for "PL/SQL" and "PL/SQL CLOB" Documents

You can integrate a document into a workflow process by defining an attribute of type document for an item type, message, or activity. Oracle Workflow supports document types called "PL/SQL" documents and "PL/SQL CLOB" documents. A PL/SQL document represents data as a character string, while a PL/SQL CLOB document represents data as a character large object (CLOB).

The document-type attribute that you create tells Oracle Workflow how to construct a dynamic call to a PL/SQL procedure that generates the document. You can embed a PL/SQL document-type message attribute in a message body to display the document in a notification.

Attention: Only notifications viewed from the Notifications Worklist can include PL/SQL CLOB documents. You cannot use PL/SQL CLOB documents in e-mail notifications sent through the Notification Mailer.

The PL/SQL procedures that generate PL/SQL and PL/SQL CLOB documents must follow standard API formats.

Standard APIs for "PL/SQL" and "PL/SQL CLOB" Documents

See Also