When executing the a query in Toad for Oracle, the query executes correctly the first time. However, subsequent executions cause a 'Stack overflow' error.
Here is the Exception generated:
Exception:
-------------------------------------------------------
2.1 Date : Mon, 6 Aug 2012 11:59:04 -0400
2.2 Address : 100BEB47
2.3 Module Name : oci.dll - (Oracle Call Interface)
2.4 Module Version: 11.2.0.1
2.5 Type : EStackOverflow
2.6 Message : Stack overflow.
2.7 ID : 4238
2.8 Count : 1
2.9 Status : New
2.10 Note :
NLS_Lang environment variable is set to a bad value.
Change your NLS_LANG environment variable to AMERICAN_AMERICA.WE8MSWIN1252.
If you select Help | Toad Advisor, it will tell you if your NLS_LANG environment variable is set to a bad value.
