oracle procedure with particular parameters

ray.wurlod · Post by **ray.wurlod** » Fri May 15, 2015 2:04 am

'M' is not a valid day of the week.

ORA-20000: -1846 - ORA-01846: not a valid day of the week ORA-06512

chulett · Post by **chulett** » Fri May 15, 2015 7:23 am

Not sure if this helps or not. And we can't really answer your proc question without seeing the actual procedure's pl/sql code.

huge10 · Post by **huge10** » Thu May 21, 2015 6:13 am

The problem was in the NLS_LANGUAGE setting for the DB.

Developing the oracle procedure with Toad or SQLTools I couldn't see that the default language was setted to ITALIAN.
Datastage set the default language to ENGLISH.

Inside the procedure there is some date function with the name of the day ... so with Toad or SQLTool the procedure doesn't catch any error, when the same procedure is launched by Datastage the "italian" name of the day is unrecognized and generates the error.

ray.wurlod · Post by **ray.wurlod** » Thu May 21, 2015 4:38 pm

That seems reasonable. How did you correct it? Presumably you set the NLS_LANGUAGE for your particular connection to "ENGLISH".

huge10 · Post by **huge10** » Wed May 27, 2015 8:36 am

YES, I forced the use of NLS_LANGUAGE to "ENGLISH" inside my PL/SQL Procedure