To display user defined objects in Oracle Workflow Builder in other languages (for standalone version only)
1. Install Oracle Workflow Cartridge.
2. Create the WF_LANGUAGES view in your workflow server.
3. Run the script wfnlena.sql to enable the language of interest. See: wfnlena.sql.
4. Run the script WFNLADD.sql to create rows for the enabled language in each workflow object translation table. See: WFNLADD.sql.
5. Set the NLS_LANG environment variable for the new language.
For example, in UNIX, use the command:
setenv NLS_LANG = 'language.territory_characterset'
For Windows NT, run the regedit32 command and locate the NLS_LANG setting under the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE hierarchy. Double click on NLS_LANG, then set the variable to the new value and save your edit.
6. Create a translated version of your workflow process definition and save it as a flat file (.wft).
7. Load the translated .wft file to your workflow database, making sure that the current NLS_LANG setting is correct.
Note: In Oracle Workflow Release 2.0.3, both the Workflow Definitions Loader and the Workflow Resource Generator use the current setting of NLS_LANG to determine which language to load.
In Oracle Workflow Release 2.5, to determine the language to load, the Workflow Definitions Loader uses the language specified in the .wft file, while the Workflow Resource Generator accepts a language parameter. If you do not specify a language parameter, the Workflow Resource Generator defaults to the current setting of NLS_LANG.
