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-01858: a non-numeric character was found where a numeric was expected

Hozefa Palitanawala-OracleAug 22 2010 — edited Aug 24 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2010
Added on Aug 22 2010
9 comments
3,868 views