title: compliation error and execution error of store procedure in oracle 11g
body: <p>This is my stored procedure</p>
  
  <pre><code>create or replace procedure EMP_DB.std_stdsp
  ( stid  in out varchar(10),
   name   in out varchar(100)
  )
  is 
  begin
  select *from students s
  where S.STDID in(stid)
  and S.STDNME in (name);
  end EMP_DB.std_stdsp;
  /
  </code></pre>
  
  <p>compilation error</p>
  
  <p>Warning: compiled but with compilation errors</p>
  
  <p>When i execute stored procedure,i got an error</p>
  
  <pre><code>EXEC EMP_DB.std_stdsp('1','Farhat');
  </code></pre>
  
  <p>Error</p>
  
  <pre><code>BEGIN EMP_DB.std_stdsp('1','Farhat'); END;
  Error at line 1
  ORA-06550: line 1, column 14:
  PLS-00905: object EMP_DB.STD_STDSP is invalid
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  </code></pre>
  
  <p>Any one help me.Thanks in advance</p>