Home » Developer & Programmer » Application Express & MOD_PLSQL » Form Error (Application Express, 4.0, windows 7)
Form Error [message #533496] Wed, 30 November 2011 04:42 Go to next message
abarnybox
Messages: 49
Registered: November 2011
Member
Hi,

Encounterring an error on some but not all forms:
it says 'A non-numeric character was found in the place of a numeric character' or something like that (Its actually in french 'Caractère non numérique trouvé à la place d'un caractère numérique' but yeh thats translated). I don't understand why it says it, the only field in the form which is numeric is the ID, the rest are text or date (don't know if dates count maybe?) and when I set the ID to number and manually input a number it still does it. I've also tried just inputting numbers into all fields but it makes no difference...

anyone know what the problem is and how to fix it?
thanks

abarnybox
Re: Form Error [message #533497 is a reply to message #533496] Wed, 30 November 2011 04:47 Go to previous messageGo to next message
Littlefoot
Messages: 19605
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A DATE column might be a culprit, if date format you entered is different from the one Oracle expects. For example: if it expects DD.MM.YYYY (such as 30.11.2011) and you enter DD-MON-YY (such as 30-NOV-11), these aren't compatible and raise an error. Could you check it?
Re: Form Error [message #533499 is a reply to message #533497] Wed, 30 November 2011 04:53 Go to previous messageGo to next message
abarnybox
Messages: 49
Registered: November 2011
Member
Ah that was it I have a DATE_CREATED column which I want to fill automatically so I had it hidden and default value 'sysdate'. so i changed it to date picker and changed the date format to DD.MM.YYYY and it worked.
Just seems strange cos the same thing works in other forms...

Is the 'sysdate' thing right? or is there another way of getting the current date automatically?

[Updated on: Wed, 30 November 2011 04:57]

Report message to a moderator

Re: Form Error [message #533506 is a reply to message #533499] Wed, 30 November 2011 05:20 Go to previous message
Littlefoot
Messages: 19605
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SYSDATE is the right way.
Previous Topic: log in with cookies
Next Topic: A bit of form help
Goto Forum:
  


Current Time: Wed Sep 17 06:39:23 CDT 2014

Total time taken to generate the page: 0.05536 seconds