Home » Developer & Programmer » Forms » How can I check if my input is character or numeric(oracle forms)
How can I check if my input is character or numeric(oracle forms) [message #82535] Thu, 05 June 2003 06:27 Go to next message
LALA
Messages: 18
Registered: August 2002
Junior Member
hi all,

i wanted to check if the inputed value on my textitem is character or numeric. kindly give me the sample syntax
thanks
Re: How can I check if my input is character or numeric(oracle forms) [message #82541 is a reply to message #82535] Thu, 05 June 2003 16:01 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
try this

if to_number(:field_value)>=0 or to_number(:field_value)<0 then
message('its number');
end if;

exception
when others then
message('its not number');
Previous Topic: How to call an bmp file in image item
Next Topic: Enter Query in multiple blocks
Goto Forum:
  


Current Time: Mon May 16 15:58:50 CDT 2022