 Password Validation in Oracle 6i forms [message #663217] |
Fri, 26 May 2017 01:23  |
 |
Usman_Khan
Messages: 3
Registered: May 2017
|
Junior Member |
|
|
I am creating a Sign up form in which i have User_Password Textfield, and i want to validate that field on the basis of following parameters:
1. Password should have Atleast 1 Capital letter
2. Password should have Atleast 1 Small Letter
3. Password should have Atleast 1 Special Charater(i.e @,#)
4. And in Last Password should have 1 numeric Charater atleast.
Below Code is Not working..
Quick Response will be appericiated.
declare
v_ascii number;
begin
select ascii(:user_pass) into v_ascii from dual;
if :user_pass is null
then
message('Please Enter the Password');
message('Please Enter the Password');
raise form_trigger_failure;
elsif (v_ascii between 65 and 90) or (v_ascii between 97 and 122) and (v_ascii between 35 and 64)
then
null;
else
message('Password Should have Alpha-Numeric');
message('Password Should have Alpha-Numeric');
raise form_trigger_failure;
end if;
end;
[Updated on: Fri, 26 May 2017 01:24] Report message to a moderator |
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
