Restrict user input in Forms

[ManjulaMadhu]

Is there an easy way to restrict user from entering anything besides letters and numbers into a varcharfield on the Oracle Form?

 

[R1972]

Hi,
There is an item property Data type - select Alpha instead of Char. This will accepts only alphabetics and space

Regards,
Rajesh

 

[lewisp]

Alpha will restrict to lower and uppercase letters only (and space). You will need to put something like the following into a WHEN-VALIDATE-ITEM trigger:

DECLARE
l_test VARCHAR2(255);
BEGIN
l_test := Replace(Translate(Upperblock.field),'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789 ','aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'),'a',NULL);
--
IF l_test IS NOT NULL
THEN
Message('Invalid character');
Raise FORM_TRIGGER_FAILURE;
END IF;
END;