Saturday, October 12, 2013

Learning more about Oracle Alerts

As a follow up to my previous article on Oracle Alerts, when I had shared that information with my team one of my co-workers pointed out that we should do Run as well as Verify because it could pick up other issues with your alert.  So remembering that, I went to another alert which was erroring and Verify gave me the thumbs up but Run gave me the error being encountered:

APP-ALR-04108: SQL error ORA-01840: input value not long enough for date format

In the details for the alert are several variable lengths defined and one of the variables is too short for the date information being passed into it.

No comments:

Post a Comment