title: How to write a Procedure with multiple operations like select and update
body: <p>Table</p>
  
  <pre><code>Id
  Count
  </code></pre>
  
  <p>I want to write a procedure to find '<code>Count</code>' in the table with '<code>Id</code>' as key.After getting '<code>count</code>' i have to increment it and update back in the table for that '<code>Id</code>'.How can I write this with procedure without using cursors.</p>
  
  <p>I want a simple procedure like below, BUT ITS NOT EXECUTING.IT SAYS PROCEDURE SUCCESSFUL WITH COMPILATION ERRORS.Help me out.</p>
  
  <pre><code>create or replace PROCEDURE newpro( inId IN NUMBER, outcount OUT NUMBER) is
  select COUNT into outcount from Table1 WHERE ID= inId ;
  BEGIN 
  outcount := outcount +1; 
  update Table1 set COUNT = outcount WHERE ID = inId ; 
  END;
  </code></pre>