Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with procedure,PLS-00306: wrong number or types of arguments in cal

mgaldamesAug 10 2010 — edited Aug 11 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2010
Added on Aug 10 2010
9 comments
2,538 views