Contents	Index	Glossary	Master Index	Feedback

• 1. Enter a string that identifies the document in the default value field of the Attribute property page.

• You can identify the following types of document for a document attribute:

• 2. A PL/SQL document represents data from the database as a character string, generated from a PL/SQL procedure. Specify the default value of a PL/SQL document as

 plsql:<procedure>/<document_identifier>.

• Replace <procedure> with the PL/SQL package and procedure name, separated by a period. Replace <document_identifier> with the PL/SQL argument string that you want to pass directly to the procedure. The argument string should identify the document.

Note: The PL/SQL procedure must follow a standard API format. See: Standard APIs for "PL/SQL" and "PL/SQL CLOB" Documents.

• For example, the following string represents the PL/SQL document, po_req:2034, generated by the procedure po_wf.show_req.

 plsql:po_wf.show_req/po_req:2034

Note: The maximum length of the data that a PL/SQL document can contain is 32 kilobytes. If you expect your document to exceed 32 Kb, you should use a PL/SQL CLOB document to hold the data instead.

• 3. A PL/SQL CLOB document represents data from the database as a character large object (CLOB), generated from a PL/SQL procedure. Specify the default value of a PL/SQL CLOB document as

 plsqlclob:<procedure>/<document_identifier>.

• Replace <procedure> with the PL/SQL package and procedure name, separated by a period. Replace <document_identifier> with the PL/SQL argument string that you want to pass directly to the procedure. The argument string should identify the document.

Note: The PL/SQL procedure must follow a standard API format. See: Standard APIs for "PL/SQL" and "PL/SQL CLOB" Documents.

• For example, the following string represents the PL/SQL CLOB document, po_req:2036, generated by the procedure po_wf.show_req_clob.

 plsqlclob:po_wf.show_req_clob/po_req:2036

• PL/SQL CLOB documents do not support further substitution of message attribute tokens. The contents of the CLOB are printed in the message body as they are generated by the PL/SQL procedure.

• 4. If you wish to generate the document identifier for a PL/SQL or PL/SQL CLOB document dynamically, you can token substitute the document identifier with other item type attributes. The item attribute names must be in uppercase and must be separated by a colon. See: To Token Substitute an Attribute.

• For example:

 plsql:po_wf.show_req/&ITEM_ATTR1:&ITEM_ATTR2

Note: If you are defining a message attribute of type Document, you can also include a special token in your argument string called &#NID which Oracle Workflow substitutes with the notification ID of the runtime notification.

• 5. Choose OK when you are done.

Copyright © 1996, 2002 Oracle Corporation.
All Rights Reserved.