OraFAQ Forum: Forms » Field Input Validation to Check User Inputs

Home » Developer & Programmer » Forms » Field Input Validation to Check User Inputs (Trigger)

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

Field Input Validation to Check User Inputs [message #413949]

Sun, 19 July 2009 10:47

Only-Oracle
Messages: 53
Registered: June 2009

Member

hi everybody

I'm facing a problem. I'm creating a form and there is a field in the form I want to make a restriction on the field so the user can't enter less than 4 characters and it also if it's possible to have restriction not entering more than 16 characters. So which trigger shall I use for. Please help me

I did here a code but it's not working with me:

IF :PASSWORD1 < 4 THEN
message('Password should be at least 6 character.');
display_error;
raise form_trigger_failure;

ELSIF :PASSWORD1> 16 THEN
message('ERROR: Password should not exceed more than 16 character.');

display_error;
raise form_trigger_failure;
END IF;

Report message to a moderator