'M' is not a valid day of the week.
ORA-20000: -1846 - ORA-01846: not a valid day of the week ORA-06512
oracle procedure with particular parameters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
![Smile :-)](./images/smilies/icon_smile.gif)
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.
![Smile :-)](./images/smilies/icon_smile.gif)
the power is nothing without contol ![Smile :-)](./images/smilies/icon_smile.gif)
![Smile :-)](./images/smilies/icon_smile.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: