Problem with procedure,PLS-00306: wrong number or types of arguments in cal
Hello there i have this package
CREATE OR REPLACE
PACKAGE TESTER AS
TYPE t_ref_cur IS REF CURSOR;
PROCEDURE getRS (p_recordset OUT t_ref_cur);
END;
CREATE OR REPLACE
PACKAGE BODY TESTER AS
PROCEDURE getRS (p_recordset OUT t_ref_cur) AS
BEGIN
OPEN p_recordset FOR
SELECT
name,
value
FROM
Parameters;
END;
END;
I just want to get the rows from table parameters and return a Cursor to my java application. The procedure is called using ibatis. But when i test the Procedure i get this error
ORA-06550: línea 3, columna 3:
PLS-00306: wrong number or types of arguments in call to 'GETRS'
ORA-06550: línea 3, columna 3:
PL/SQL: Statement ignored