ORA-01840 error (input value not long enough for date format)
504039Apr 13 2006 — edited Apr 16 2006I keep getting this error when I try to save the changes. Does anybody know what could be the problem. I never came across this error and dont really understand. The date that gets set is the sys date ... 11 characters ... in the tables the field is also set to DATE.
Below is my save changes button:
---------------------------------------------------------------------------------------
INSERT INTO orderline VALUES
(:orders.orderlineid,
:orders.clientid,
:orders.datestart,
:project.projectid,
:location.locationid,
:cl.clid);
COMMIT;
---------------------------------------------------------------------------------------------------
Cause: The data to be converted to date format was incomplete; the date format picture was longer than the input data.
Action: Either add more input or shorten the date picture format, then retry the operation.
Help much appreciated
Message was edited by:
Baraka