title: How to use select statement in oracle stored procedure
body: <pre><code>CREATE OR REPLACE PROCEDURE get_pop1()
  DECLARE
  ROUTERNAME varchar2(100);
  BEGIN
  SELECT ROUTERNAME INTO routername FROM INTERFACE_ATTLAS;
  END;
  </code></pre>
  
  <p>I tried to execute this procedure. But it gives error. Please anyone tell me whats mistake I have done. </p>