title: Two or more calcul in a request in PLSQL
body: <p>I'm trying to make two agregations and return the values in a stored procedure.
  This is my table :</p>
  
  <pre><code>CREATE TABLE T_TEST (TEST NUMERIC(10) ) ;
  INSERT INTO T_TEST VALUES (1) ;
  INSERT INTO T_TEST VALUES (2) ;
  INSERT INTO T_TEST VALUES (3) ;
  </code></pre>
  
  <p>This works :</p>
  
  <pre><code>DECLARE
    vSUM NUMERIC(10) ;
    vCOUNT NUMERIC(10) ;
  BEGIN
    SELECT SUM(TEST) AS SUM INTO vSUM FROM T_TEST ;
    DBMS_OUTPUT.PUT_LINE(vSUM) ;
  END;
  </code></pre>
  
  <p>outside of the sp, this works ;</p>
  
  <pre><code>SELECT SUM(TEST) AS SUM , COUNT(TEST) AS NB FROM T_TEST ;
  </code></pre>
  
  <p>but this doesn't :</p>
  
  <pre><code> DECLARE
     vSUM NUMERIC(10) ;
     vCOUNT NUMERIC(10) ;
   BEGIN
     SELECT 
       SUM(TEST) AS SUM INTO vSUM, 
       COUNT(TEST) AS NB INTO vCOUNT
     FROM T_TEST ;
     DBMS_OUTPUT.PUT_LINE(vSUM) ;
     DBMS_OUTPUT.PUT_LINE(vCOUNT) ;
   END;
  </code></pre>