Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    8

    Unanswered: Warning about Oracle Workflow views

    The metadata views of Oracle Workflow use the variable userenv('LANG') a lot (see example below).
    It costed me 2 hours to figure out why certain views were empty when examined from one machine and not empty from another client.

    Well, in case you run into the same problem, this is a possible cause.


    CREATE OR REPLACE VIEW WF_LOOKUPS
    (ROW_ID, LOOKUP_TYPE, LOOKUP_CODE, PROTECT_LEVEL, CUSTOM_LEVEL,
    MEANING, DESCRIPTION)
    AS
    select /* $Header: wfcorev.sql 26.0 2000/07/05 23:42:38 kma ship $ */
    B.ROWID ROW_ID,
    B.LOOKUP_TYPE,
    B.LOOKUP_CODE,
    B.PROTECT_LEVEL,
    B.CUSTOM_LEVEL,
    B.MEANING,
    B.DESCRIPTION
    from WF_LOOKUPS_TL B
    where B.LANGUAGE = userenv('LANG')

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    I just stumped upon a similar problem but with OUI (Oracle Universal Installer), interactive installation. It was not able to find the oraparam.ini even though when launched from CD. This was trying to be done on a computer with spanish as the os language. Turned out to be OUI choosing a different language than the OS, changing the LANG regedit key fixed the problem.

    Thanks for letting us know this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •