title: how do i run multiple select statements in oracle procedure
body: <p>I have written the following procedure</p>
  <pre><code>create or replace procedure sp_abc_profile 
  (
    f_symbol_in abc.colname%TYPE
  )
  is profile abc%rowtype;
  is profile2 abc2%rowtype;
  begin
    SELECT fname, lname,mname,age
      INTO profile
    FROM abc
    WHERE f_symbol = f_symbol_in;
  
    SELECT initiaiinvestment AS minInitialInvestment, pr as qt, class1 as clss
      into profile2
    FROM 
        abc2 
    WHERE f_symbol = f_symbol_in;
  end;
  </code></pre>
  <p>Upon executing the above I get error message as follows:</p>
  <blockquote>
  <p>Error(7,3): PL/SQL: SQL Statement ignored</p>
  <p>Error(21,5): PL/SQL:ORA-00913: too many values</p>
  </blockquote>
  <p>I don't want to select all the rows in both tables.</p>
  <p>How can I write multiple select statements in a procedure, so that every single select statement in procedure returns a resultset.</p>