Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Invalid Number (Apex 4.0,Oracle 10g)
Invalid Number [message #629902] Wed, 17 December 2014 03:43 Go to next message
Messages: 235
Registered: January 2014
Location: India
Senior Member
Hello All,

In my up-datable sql report one text field "Qty" with "999G999G999G999G990D00" Number format. when user type 1000 and save the data then Qty shows like 1,000 but when user again click on save button then the invalid number error raise by apex because of format mask.

when I remove the format mask of the field then It'll work correctly. but how can I avoid this problem? Why format mask create such type of problem?

Please help me out!!


Re: Invalid Number [message #629935 is a reply to message #629902] Wed, 17 December 2014 15:36 Go to previous message
Messages: 21795
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is "up-datable sql report"? Sounds like a tabular form, but I can't tell for sure.

Anyway: I tested what you explained on a tabular form I created. I can't reproduce what you are explaining on my Apex 4.2. If possible, create that page on apex.oracle.com and let us know credentials so that we could take a look.
Previous Topic: NEW TO APEX and Exploring. Please help
Next Topic: Excel Import Issue
Goto Forum:

Current Time: Thu Nov 30 09:23:46 CST 2023