This discussion is archived
9 Replies Latest reply: Dec 4, 2012 8:13 AM by VC RSS

Error If Wrong Decimal Seperator

Gus C Journeyer
Currently Being Moderated
I am using Apex 3.2

Our database and apex instances are set up to use a decimal point in number values (NLS_LANGUAGE = AMERICAN)
A lot of our users are German and in Germany they use a comma as the decimal seperator.
When ever they enter a comma instead of a point, I need to give an error on the page.
At the moment in our page processes, we use
exception
  when others then
   if sqlcode=-6502 
     then 
       rollback;
       :P9_ERROR:='Please use points as decimal separator';
     else
      raise;
   end if;
:P9_ERROR is a hidden page item and then in the process success message, we put &P9_ERROR.

Is there a better way to do this.
The error message ust appear on the page and not on the error page

Thanks

Gus

Edited by: Gus C on Dec 4, 2012 12:02 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points