home bbs files messages ]

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