title: sql error (-659) into temp table required for select statement
body: <p>I try to create a simple stored procedure which should return a data set as a result of select statement. like this :</p>
  
  <pre><code>CREATE PROCEDURE rr_reward()
  
  SELECT a.emp_num,a.emp_name
  FROM emp_data a
  WHERE a.active_code = 1
  
  END PROCEDURE
  </code></pre>
  
  <hr>
  
  <p>but I get the following error:</p>
  
  <blockquote>
    <p>sql error (-659) into temp table required for select statement</p>
  </blockquote>