Error while getting record set from the stored proc of the oracle RSS

• • Reply
  

  rupakraj

  Member

  1 Points

  1 Post

  Error while getting record set from the stored proc of the oracle

  Jan 27, 2011 09:30 AM|LINK

  Hello, i am getting this error while fetching select statement in oracle pl/sql proc... ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_CLASS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored My proc is like.. PROCEDURE "SP_CLASS" ( iDec IN NUMBER := null, p_ICID in number := null, p_DATA OUT SYS_REFCURSOR) IS BEGIN if(iDec = 1) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS; else if(iDec = 2) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS where ICID = p_ICID ; end if; end if; END;
• • Reply
  

  Sibin

  Participant

  1053 Points

  252 Posts

  Re: Error while getting record set from the stored proc of the oracle

  Jan 27, 2011 10:13 AM|LINK

  Hi,

   

  1) Check the number of parameters passing from application with the procedure parameters.

  2) Check the parameter types passing from the application , it should be same as that of procedure.

   

  This might solve your problem.

  Please: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue
  :) Sibi :)
  http://www.xpertbits.com
  • Marked as answer by rupakraj on Jan 30, 2011 02:11 AM