title: How to create/call procedure in oracle 10g?
body: <p>I created a procedure in Oracle but am getting an error when I attempt to execute it. Below are listed the steps I am taking to create this procedure:</p>
  
  <pre><code>SQL&gt; ed getuserinfo
  
  create or replace procedure getUserInfo
      ( p_username out Users.username%TYPE,
        p_password out Users.password%TYPE ) IS
  BEGIN
  
      select username,password into p_username,p_password from users where username='yogi';
  
  END;
  /
  
  
  SQL&gt; exec getuserinfo
  BEGIN getuserinfo; END;
  
            *
  ERROR at line 1:
  ORA-06550: line 1, column 7:
  PLS-00201: identifier 'GETUSERINFO' must be declared
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  </code></pre>
  
  <p>What is the problem and how can I solve it? Olease can anyone help me?</p>