PROCEDURE CHECK_PROC (u_username in users.username%type,p_password in users.password%type,o_roleid out users.roleid%type,o_firstname out users.firstname%type, o_lastname out users.lastname%type,o_userid out users.userid%type) AS cursor check_cur is select roleid,firstname,lastname,userid from users where username=u_username and password=p_password; BEGIN open check_cur; loop fetch check_cur into o_roleid,o_firstname,o_lastname,o_userid ; exit when check_cur%notfound; dbms_output.put_line(o_roleid || '' || o_firstname ||''|| o_lastname ||''||o_userid); end loop; close check_cur; END CHECK_PROC;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)