title: PL/SQL array into refcursor to return
body: <p>I'm new to PL/SQL. I need to convert an array into a refcursor to return the record set. this is how SP looks like:</p>
  
  <pre><code>PROCEDURE EXAMPLE(p_recordset OUT SYS_REFCURSOR) AS
   TYPE COUNTRY_ARR IS TABLE OF VARCHAR2(60) INDEX BY BINARY_INTEGER;
   V_COUNTRY_ARR COUNTRY_ARR; 
   BEGIN    
      V_COUNTRY_ARR(1) := 'US';
      V_COUNTRY_ARR(2) := 'AUS';
      V_COUNTRY_ARR(3) := 'NA';
  
      OPEN p_recordset FOR SELECT * FROM TABLE(CAST(V_COUNTRY_ARR AS COUNTRY_ARR)); 
   END EXAMPLE;
  </code></pre>
  
  <blockquote>
    <p>Gives me an error saying 'Error(86,68): PL/SQL: ORA-00902: invalid
    datatype'</p>
  </blockquote>
  
  <p>Thank you in advance!</p>