NLS Error in DSExecute routine
Posted: Tue Sep 13, 2011 3:53 am
Hi,
I'm using DSExecute routine in a batch job to run some sql in oracle DB. DSExecute calls a unix shell script which in turn connects to DB and execute a sql file with multiple sql statements.
Job is running fine in old projects. We created a new project recently but the routine call is failing in new project with below error as the cmd_output from the routine.
"ERROR:ORA-12705: invalid or unknown NLS parameter value specified"
Please let me know if I need to make some changes in new project as this was first execution in this project and is failing with said error.
Thanks,
Shashank
I'm using DSExecute routine in a batch job to run some sql in oracle DB. DSExecute calls a unix shell script which in turn connects to DB and execute a sql file with multiple sql statements.
Job is running fine in old projects. We created a new project recently but the routine call is failing in new project with below error as the cmd_output from the routine.
"ERROR:ORA-12705: invalid or unknown NLS parameter value specified"
Please let me know if I need to make some changes in new project as this was first execution in this project and is failing with said error.
Thanks,
Shashank