create a login page using when button is pressed trigger
767628Apr 19 2010 — edited Apr 20 2010I need to write a code that allows users to enter their name and password and there organisation type. If the organisation type entered is staff they are takeing to the appropriate block if it is courts they are taken to another block. This is what I am stuck on. If anyone could help I would be extremley grateful.
declare
staff_id varchar2(4);
user_password varchar2(8);
org varchar2(10);
alert_button number;
begin
select employee_no,n_password,organisation_type
into staff_id, user_password,org
from organisation
where :login.text_item_user_name=organisation.employee_no and :login.text_item_type= organisation.organisation_type;
if(staff_id =:login.text_item_user_name AND user_password =:login.text_item_password)
then go_block('Driving_Test');
else
else
alert_button := show_alert ('Alert_Incorrect_Login');
if alert_button= alert_button1 then
clear_block;
end if;
end if;
end if;
end;