title: selecting multiple columns in pl/sql collection
body: <p>Actually i have created following procedure,which is working fine.</p>
  
  <pre><code>CREATE or REPLACE PROCEDURE GET_NOS(
  firstDate IN DATE,
  secondDate IN DATE,
  thirdDate IN DATE,
  fourthDate IN DATE,
  test IN VARCHAR2,
  Slnt_Entity OUT TEST.RefCsr
  )
  AS
   DemoTable CRITERIA_LIST_TABLE;
   BEGIN
  
  
  SELECT column1 BULK COLLECT INTO DemoTable FROM opr_test where call_date between firstDate AND secondDate AND id=test
  MINUS
  SELECT column1 FROM opr_test where call_date between thirdDate AND fourthDate AND id=test;
  
  
  OPEN Slnt_Entity FOR SELECT * FROM TABLE(
                                              CAST (
                                                      DemoTable AS CRITERIA_LIST_TABLE
                                                   )
                                      ) Nos;
  
  END;
  /
  </code></pre>
  
  <p>2. second</p>
  
  <pre><code>create or replace TYPE "CRITERIA_LIST_TABLE" as table of varchar2(20);
  /
  </code></pre>
  
  <ol>
  <li><p>Third</p>
  
  <pre><code>create or replace PACKAGE "TEST"
  AS
  TYPE RefCsr IS REF CURSOR;
  END TEST;
   /
  </code></pre>
  
  <p>Now i want to change my query like this</p>
  
  <pre><code>SELECT column1,column2 BULK COLLECT INTO DemoTable FROM opr_test where call_date between firstDate AND secondDate AND id=test
  MINUS
  SELECT column1,column2 FROM opr_test where call_date between thirdDate AND fourthDate AND id=test;
  </code></pre></li>
  </ol>
  
  <p>so i changed the procedure like</p>
  
  <pre><code>CREATE or REPLACE PROCEDURE GET_NOS(
  firstDate IN DATE,
  secondDate IN DATE,
  thirdDate IN DATE,
  fourthDate IN DATE,
  test IN VARCHAR2,
  Slnt_Entity OUT TEST.RefCsr
   )
  AS
  
  CURSOR c1 IS SELECT column1,column2 FROM opr_test;
    create or replace TYPE "ABC" IS TABLE OF c1%ROWTYPE;
  DemoTable ABC;
  
  BEGIN
  
  
   SELECT column1 BULK COLLECT INTO DemoTable FROM opr_test where call_date between firstDate AND secondDate AND id=test
   MINUS
   SELECT column1 FROM opr_test where call_date between thirdDate AND fourthDate AND id=test;
  
  
    OPEN Slnt_Entity FOR SELECT * FROM TABLE(
                                              CAST (
                                                      DemoTable AS CRITERIA_LIST_TABLE
                                                   )
                                      ) Nos;
  
    END;
    /
  </code></pre>
  
  <p>But this is incorrect,please tell me how the procedure will look like</p>