Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 6i - testing text item is numeric

911012Jan 27 2012 — edited Jan 29 2012
was wondering beside using the format-mask attribute of an item.

using when-validate-item

how would I test if a text item is numeric? i wish to do this because i want write out my own error message.

is there some sort of isnumeric function in oracle forms 6i?
IF isnumeric(field) then
messagebox('Error not the right format!');
end if;
Edited by: PandaOracle on Jan 27, 2012 12:43 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2012
Added on Jan 27 2012
3 comments
1,116 views