I have a master-detail form. In the detail tabular form region I have a column on a date field. I want to save date and time in that field.
For the date field, I've set the Tabular Form Attributes Default Type to PL/SQL Expression or Function and the Default to SYSDATE.
In the Column Attributes, I've set the Display As to "Display as Text (saves state)" and the Number/Date Format to DD-MON-YYYY HH24:MI:SS.
Records queried from the table display as expected with the correct date & time format. Add Row creates a new row with the date & time also displaying with the correct format. Save however produces the following error: ORA-20001: Found invalid date value, please verify date format.
What am I doing wrong?
I'm using Oracle APEX 4.1