create or replace procedure account_validatelogin (
p_user varchar2,
p_pw number, cur out sys_refcursor)
as
v_count number(10);
v_res number(1);
begin

Select count(*) INTO v_count from ACCOUNT a where a.USERNAME = p_user and        a.PASSWORD = p_pw;
if v_count > 0 then
v_res := 1;
else
v_res := 0;
end if;

open cur for select v_res from dual;
end;
/