Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle.server    |    Oracle Sysadmins question their careers    |    44,300 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 42,628 of 44,300    |
|    franmerar229@gmail.com to All    |
|    Returning a REF cursor    |
|    30 Jul 16 17:05:57    |
      Hi,              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.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca