locked
Error while getting record set from the stored proc of the oracle RRS feed

  • Question

  • User-1605016181 posted
    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;
    Thursday, January 27, 2011 5:30 AM

Answers

  • User-1625823911 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, January 27, 2011 6:13 AM