Something like this:   
      
   CREATE OR REPLACE PACKAGE test_package AS   
      
   TYPE ref_crs IS REF CURSOR;   
      
   PROCEDURE test_procedure (   
     p_score     NUMBER,   
     p_email     VARCHAR2,   
     p_address   VARCHAR2   
     p_data  OUT REF_CRS);   
      
   END test_package;   
   /   
      
   Package created.   
      
   CREATE OR REPLACE PACKAGE BODY test_package AS   
      
   PROCEDURE test_procedure (   
     p_score     NUMBER,   
     p_email     VARCHAR2,   
     p_address   VARCHAR2   
     p_data  OUT REF_CRS) AS   
      
   BEGIN   
     OPEN p_data FOR   
       SELECT email FROM emails WHERE score = p_score;   
   END test_procedure;   
      
   END test_package;   
   /   
      
      
   Then to call it:   
      
   var data refcursor;   
      
   exec test_package.test_procedure (   
     p_score => 5,   
     p_data  => :data);   
      
   BEGIN test_package.test_procedure (; END;   
                                      *   
   ERROR at line 1:   
   ORA-06550: line 1, column 36:   
   PLS-00103: Encountered the symbol ";" when expecting one of the following:   
   ( ) - + case mod new not null    
      
      
   Any thoughts on this one?   
      
   Thanks!!   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)