title: Why is Oracle SELECT INTO statement throwing error?
body: <p>I write a code to create procedure in oracle, It's successful created but when RUN from sql developer to view output it's show error.</p>
  
  <pre><code>ORA-01422: exact fetch returns more than requested number of rows
  ORA-06512: at "TESTUSER.USER_FEEDBACK", line 5
  ORA-06512: at line 2
  </code></pre>
  
  <p>code:</p>
  
  <pre><code>create or replace PROCEDURE user_feedback
  IS
  initiator VARCHAR2(50);
  BEGIN
  select first_name into initiator
  from person_info;
  END ;
  </code></pre>
  
  <p>Please suggest me.</p>