daily pastebin goal
46%
SHARE
TWEET

Untitled

a guest Aug 13th, 2016 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create or replace procedure account_validatelogin (
  2. p_user varchar2,
  3. p_pw number, cur out sys_refcursor)
  4. as
  5. v_count number(10);
  6. v_res number(1);
  7. begin
  8.  
  9. Select count(*) INTO v_count from ACCOUNT a where a.USERNAME = p_user and        a.PASSWORD = p_pw;
  10. if v_count > 0 then
  11. v_res := 1;
  12. else
  13. v_res := 0;
  14. end if;
  15.  
  16. open cur for select v_res from dual;
  17. end;
  18. /
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top