Click here to Skip to main content
15,797,822 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
create or replace
SQL
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;

this is my procedure and while executing i am getting wrong number or types of arguments error plz plz help me out
exec check_cur('',''); this is how i am executing
Posted
Updated 28-May-13 4:30am
v2

1 solution

 
Share this answer
 
Comments
Member 10057465 28-May-13 9:51am    
i am doing .net so plz help me out...
Suvabrata Roy 28-May-13 13:18pm    
let me know your code...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900