Oracle Error: ORA-00942 [message #93025] |
Mon, 23 September 2002 10:04 |
mikeZ
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 #93101 is a reply to message #93025] |
Sun, 19 January 2003 05:01 |
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
|
|
|