Home » Developer & Programmer » Data Integration » Oracle Error: ORA-00942
Oracle Error: ORA-00942 [message #93025] Mon, 23 September 2002 10:04 Go to next message
Messages: 2
Registered: September 2002
Junior Member
When I want to access data warehouse through a Workflow Builder, I get the following error.

220: Unable to set NLS_LANGUAGE.
210: Oracle Error: ORA-00942: table or view does not exist. SQL text: SELECT NLS_LANGUAGE FROM WF_LANGUAGES WHERE :l IN (NLS_LANGUAGE, CODE)

It would be much appreciated if anyone could give me a clue. Many thanks in advance.
Re: Oracle Error: ORA-00942 [message #93067 is a reply to message #93025] Tue, 10 December 2002 01:22 Go to previous messageGo to next message
Messages: 1
Registered: December 2002
Junior Member

no solution but facing the same problem. Have you solved it yet and how?
Re: Oracle Error: ORA-00942 [message #93101 is a reply to message #93025] Sun, 19 January 2003 05:01 Go to previous message
Tarek Tadross
Messages: 1
Registered: January 2003
Junior Member
there is a Key in the Registry called NLS_LANG
run regedit
then search for NLS_LANG
the Value is somthing like this "AMERICAN_AMERICA.AR8MSAWIN"
u should remove the ".AR8MSAWIN" and place it the same as ur server lang

if u wanna know ur server language

connect as system/manager
then write this sql statment

select value$
from sys.props$
where name like 'NLS_CHARACTERSET';

best reguards
Previous Topic: synonym message
Next Topic: Data Warehousing person required
Goto Forum:

Current Time: Wed Nov 30 18:57:48 CST 2022