ORA-01858: a non-numeric character was found where a numeric was expected
On submitting a form, I keep on getting the error: "ORA-01858: a non-numeric character was found where a numeric was expected"
The description I found for this error is: "You are trying to convert a string to a date using the TO_DATE function, but the string does not match the format mask.
An alpha numeric character was found when a numeric character was expected."
I've got 3 date fields but they are not required and I get this error even if I don't enter any value in the fields.
Have anyone faced similar issue?
You can see the page at: http://apex.oracle.com/pls/apex/f?p=11955:14:
User Name/Password: vhms/hozy
Thanks for the help.
--Hozy