Oracle Forms | How To Create Basic Login Page -38

Oracle Forms | How To Create Basic Login Page -38
To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU
To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY

Dear viewer, In this tutorial you will learn how to easily create a login page with Oracle Forms Builder.

declare
v_record user_info1%rowtype;
begin
:ERR_MESS:='';
select * into v_record from USER_INFO1
where USER_NAME=:CONTROL.USERNAME;
IF
v_record.USER_PASS=:CONTROL.PASS THEN
--:global.USER_NAME:=v_record.USER_NAME;
--:global.memid:=v_record.memid;
IF
v_record.USER_TYPE= 'admin' then
open_form('E:\Micro Credit Project\All Pages\HOME_PAGE.fmx');
elsif
v_record.USER_TYPE='operator' then
open_form('E:\Micro Credit Project\All Pages\member_PAGE.fmx');
elsif
v_record.USER_TYPE='audit' then
open_form('E:\Micro Credit Project\All Pages\group_PAGE.fmx');
end if;
elsif v_record.USER_PASS ():CONTROL.PASS THEN
:ERR_MESS:=('Invalid Password!!');
elsif :CONTROL.PASS is null THEN
:ERR_MESS:=('Please enter username/Password!!');
elsif :CONTROL.USERNAME is null THEN
:ERR_MESS:=('Please enter username/Password!!');
end if;
exception
when others then
:ERR_MESS:=('Invalid Username/Password!!');
end;

To Get more Tutorial Subscribe The Channel
click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1

To Get All Post Like The Facebook Page
Click here https://www.facebook.com/oracledbsolutions

Follow us:
Facebook: https://www.facebook.com/oracledbsolutions
Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber
Facebook Group: https://www.facebook.com/groups/465557066961548

Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780