Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-20505: Error in DML: ORA-01847

tfaJul 29 2009 — edited Jul 29 2009
I'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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2009
Added on Jul 29 2009
4 comments
812 views