"To Create Lookup Types (Oracle Workflow Developer's Guide)

Oracle Workflow Developer's Guide
Release 2.6.3
Part Number B10284-02


	Previous	Next		Contents	Index	Glossary

To Create Lookup Types

1. Select an item type from the navigator tree and choose New Lookup Type from the Edit menu. A Lookup Type property page appears.

2. Lookup types have an all-uppercase Internal Name with no leading/trailing spaces and a translatable Display Name. All Oracle Workflow APIs, SQL scripts, and PL/SQL procedures refer to the internal name when identifying a lookup type.

Attention: To update the internal name for a lookup type once it is defined, you must use a special SQL script called wfchlut.sql. You should only use this script to correct errors in a lookup type's internal name during design time. Do not use this script to rename lookup types that are involved in running instances of processes. See: Wfchlut.sql, Oracle Workflow Administrator's Guide.

Caution: Do not include colons ":" or leading/trailing spaces in your internal name.

You can supply an optional description for this lookup type.

3. Select the Access tab page to set the access levels allowed to modify this lookup type. See: Allowing Access to an Object.

4. Choose Apply to save your changes, OK to save your changes and close the property page or Cancel to cancel your changes and close the property page.

5. The lookup type you just defined now appears beneath the Lookup Types branch in the navigator tree. You can review or edit the properties of this lookup type at any time by double-clicking on the lookup type in the navigator tree or by selecting the lookup type and choosing Properties from the Edit menu.

6. Now define the lookup codes for your lookup type. See: To Create Lookup Codes for a Lookup Type.

To Create Lookup Types

See Also