OraFAQ Forum: Forms » Password Validation in Oracle 6i forms

Home » Developer & Programmer » Forms » Password Validation in Oracle 6i forms (Oracle Form Builder 6i) (

) 1 Vote

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

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

Re: Password Validation in Oracle 6i forms [message #663219 is a reply to message #663217]

Fri, 26 May 2017 01:32

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 27 00:02:13 CDT 2025