1 Reply Latest reply: Jun 18, 2013 4:34 PM by Klabautermann RSS

    Error inserting sysdate with time in tabular form region


      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