OraFAQ Forum: Forms » How can I check if my input is character or numeric(oracle forms)

Home » Developer & Programmer » Forms » How can I check if my input is character or numeric(oracle forms)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I check if my input is character or numeric(oracle forms) [message #82535]

Thu, 05 June 2003 06:27

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

Report message to a moderator

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

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');

Report message to a moderator

Previous Topic:	How to call an bmp file in image item
Next Topic:	Enter Query in multiple blocks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 27 03:06:48 CST 2025