title: Selecting a count into a variable in oracle
body: <p>Hi I have been trying this today and haven't had any luck. this stored procedure does not work :(</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE LEAD_PURGE(closed IN DATE,
  oprtr IN INTEGER,
  leadscount OUT INTEGER)
  
  is
  BEGIN
  
  SELECT COUNT(*) FROM LEADS_DELETED INTO leadscount;
  
  COMMIT;
  END LEAD_PURGE;
  </code></pre>