ORA-20505: Error in DML: ORA-01847
tfaJul 29 2009 — edited Jul 29 2009I'm getting a strange error on one of my application pages.
The errror is:
ORA-20505: Error in DML: p_rowid=105, p_alt_rowid=INSTRUCTOR_ID, p_rowid2=, p_alt_rowid2=. ORA-01847: day of month must be between 1 and last day of month
Unable to process row of table INSTRUCTORS.
Click HERE to Return to application.
I've got one date item on the page.
I've tried the following to see if I could resolve the error.
I've deleted the item and recreated it.
I've deleted the "Automatic Row Processing (DML)" process used by the page, then recreated it.
I've deleted the entire page and recreated with the same page number.
My date item is defined as a date picker with format MM/DD/YYYY.
The default format for my database DD-MON-YYYY.
Regards,
Todd