Returning a REF cursor

[Quoted] Can anyone help me with my issue on getting this code to work?

CREATE OR REPLACE PACKAGE test_package AS

TYPE ref_crs IS REF CURSOR;

PROCEDURE test_procedure (
  p_score NUMBER,
  p_data OUT REF_CRS);

END test_package;
/

CREATE OR REPLACE PACKAGE BODY test_package AS

PROCEDURE test_procedure (
  p_score NUMBER,
  p_data OUT REF_CRS) AS

BEGIN
  OPEN p_data FOR
    SELECT email FROM customer WHERE score = p_score; END test_procedure;

END test_package;

Ok, that compiled fine.........now..........

DECLARE
v_data SYS_REFCURSOR;

BEGIN
  test_package.test_procedure (
    p_score => 5,
    p_data => v_data);
END;
/

ERROR at line 5:
ORA-06550: line 5, column 3:
PLS-00306: wrong number or types of arguments in call to 'TEST_PROCEDURE'
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored

Can anyone help please?

Thank you. Received on Sun Jul 31 2016 - 02:05:57 CEST