ORA-00604

Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms
On certain Windows client :

connection using sqlplus giving the following error :
ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION


Cause
environment variable NLS_* was set between two quotas .

For example :

NLS_DATE_FORMAT= 'YYYY/MM/DD'  this should be YYYY/MM/DD



D:\oracle\product\10.2.0\db_1\BIN>set NLS_DATE_FORMAT= 'YYYY/MM/DD'

D:\oracle\product\10.2.0\db_1\BIN>sqlplus system/sys

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 23 13:17:12 2008

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION

Solution
set the environment variable without any quotas

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/563971/viewspace-617340/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/563971/viewspace-617340/