RR_4035, ORA-01843: not a valid month ERROR

We are calling one Oracle stored procedure passing one input parameter(id) from Informatica.

While executing the stored procedure directly in oracle, it is getting executed successfully without error.

However, while calling via informatica, it is throwing:

ORA-01843: not a valid month error with the specific txn id.

We are not getting any error for the error causing id (as per the error log), while executing the stored procedure directly .

Erroneous clause in SP:

--------------------------------------------
Stored procedure where clause throwing error while comparing 2- date fields
Where NVL ( <date1>, TO_DATE ('01/01/9999', 'MM/DD/YYYY'))
<> NVL (<date2>, TO_DATE ('01/01/9999', 'MM/DD/YYYY'))

3 Related questions 2 ORA-01843: not a valid month 1 ORA-08143(not a valid month) 0 ORA-01843: not a valid month Related questions 2 ORA-01843: not a valid month 1 ORA-08143(not a valid month) 0 ORA-01843: not a valid month 1 Not a valid month error in oracle 0 ORACLE - ORA-01843: not a valid month 1 ORA-01843: not a valid month error in oracle while updating 0 Not A valid Month - SQL ORA-01843 - In unix 0 ORA-01843: not a valid month with valid SQL query 0 How can I fix this error 'ORA-01843: not a valid month' 0 "not a valid month"-Oracle Load 7 more related questions Show fewer related questions Sorted by: Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.