| Oracle Workflow Guide Release 2.6.2 Part Number A95265-03 |
|
|
|
| |
|
|
||
| Contents | Index | Glossary | Master Index | Feedback |
procedure AddItemAttrTextArray
(itemtype in varchar2,
itemkey in varchar2,
aname in Wf_Engine.NameTabTyp,
avalue in Wf_Engine.TextTabTyp);
procedure AddItemAttrNumberArray
(itemtype in varchar2,
itemkey in varchar2,
aname in Wf_Engine.NameTabTyp,
avalue in Wf_Engine.NumTabTyp);
procedure AddItemAttrDateArray
(itemtype in varchar2,
itemkey in varchar2,
aname in Wf_Engine.NameTabTyp,
avalue in Wf_Engine.DateTabTyp);
Description
Adds an array of new item type attributes to the process. Although most item type attributes are defined at design time, you can create new attributes at runtime for a specific process. Use the AddItemAttributeArray APIs rather than the AddItemAttribute APIs for improved performance when you need to add large numbers of item type attributes at once.
Use the correct procedure for your attribute type. All attribute types except number and date use AddItemAttrTextArray.
Note: The AddItemAttributeArray APIs use PL/SQL table composite datatypes defined in the WF_ENGINE package. The following table shows the column datatype definition for each PL/SQL table type.
| PL/SQL Table Type | Column Datatype Definition |
|---|---|
| NameTabTyp | Wf_Item_Attribute_Values.NAME%TYPE |
| TextTabTyp | Wf_Item_Attribute_Values.TEXT_VALUE%TYPE |
| NumTabTyp | Wf_Item_Attribute_Values.NUMBER_VALUE%TYPE |
| DateTabTyp | Wf_Item_Attribute_Values.DATE_VALUE%TYPE |
| itemtype | A valid item type. |
| itemkey | A string generated from the application object's primary key. The string uniquely identifies the item within an item type. The item type and key together identify the process. See: CreateProcess. |
| aname | An array of the internal names of the new item type attributes. |
| avalue | An array of the values for the new item type attributes. |
| Previous | Next | Contents | Index | Glossary |
