Home » Developer & Programmer » Forms » Password Validation in Oracle 6i forms (Oracle Form Builder 6i)  () 1 Vote
icon4.gif  Password Validation in Oracle 6i forms [message #663217] Fri, 26 May 2017 01:23 Go to next message
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.

v_ascii number;
select ascii(:user_pass) into v_ascii from dual;
if :user_pass is null
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)
message('Password Should have Alpha-Numeric');
message('Password Should have Alpha-Numeric');
raise form_trigger_failure;
end if;

[Updated on: Fri, 26 May 2017 01:24]

Report message to a moderator

Re: Password Validation in Oracle 6i forms [message #663219 is a reply to message #663217] Fri, 26 May 2017 01:32 Go to previous message
Michel Cadot
Messages: 68595
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Have a look at Oracle standard password verification function to have an idea of how to code such function.
It is in file utlpwdmg.sql in $ORACLE_HOME/rdbms/admin directory.

Previous Topic: How to perform calculation on a particular record in datablock
Next Topic: FRM-40202: Field must be entered.
Goto Forum:

Current Time: Thu Feb 22 04:20:33 CST 2024