I'm using oracle 10g

when I run this code the call from is not working I do not know whey can you help me please

DECLARE 
x Number;	
Y BOOLEAN;
u_name LOGIN.User_Name%type; 
P_word LOGIN.Passwords%type;
u_type LOGIN.User_Type%type;
begin		

if :TEXT_ITEM17 is NULL OR :TEXT_ITEM18 IS NULL OR :TEXT_ITEM19 IS NULL THEN

	X:= SHOW_ALERT('ALERT23');


else
SELECT User_Name, Passwords,User_Type into u_name, P_word,u_type FROM Login
where User_Name=:TEXT_ITEM17 and Passwords= :TEXT_ITEM18 and User_Type= :TEXT_ITEM19 ;

Y:= SQL%found;

if y then
	x :=show_alert('alert24');
if (y) and (:TEXT_ITEM19='Administrator') then
	call_form('C:\AB\forms\admin.fmx');

	
 else 
 call_form('C:\AB\forms\User.fmx');
 end if;	
end if;
end if;

exception
	when no_data_found then
			x :=show_alert('alert25');
END;

ايه رسالة الخطا

Their is no error !!
when I run the form every thing is executed except the call form
maybe it's system problem

تأكد من جملة الشرط,,
if y then

Thank you sooooooooooo much asd202 and

المبرمج الصاعد
for helping me

The problem is that I have to run each form which is in the call form before run this code

this the correct code

DECLARE
x Number;
Y BOOLEAN;
u_name LOGIN.User_Name%type;
P_word LOGIN.Passwords%type;
u_type LOGIN.User_Type%type;
begin

if :TEXT_ITEM17 is NULL OR :TEXT_ITEM18 IS NULL OR :TEXT_ITEM19 IS NULL THEN

X:= SHOW_ALERT('ALERT23');


else
SELECT User_Name, Passwords,User_Type into u_name, P_word,u_type FROM Login
where User_Name=:TEXT_ITEM17 and Passwords= :TEXT_ITEM18 and User_Type= :TEXT_ITEM19 ;

Y:= SQL%found;

if y then
x :=show_alert('alert24');
if :TEXT_ITEM19='Administrator' then
call_form('C:\AB\forms\admin.fmx');


else
call_form('C:\AB\forms\User.fmx');
end if;
end if;
end if;

exception
when no_data_found then
x :=show_alert('alert25');
END;