title: Scheduler Oracle Stored Procedure
body: <p>I have a simple stored procedure I wanted Oracle to execute weekly and I have put it in the Oracle Scheduler. It was created fine and the scheduled task seems to execute (no error) but my stored procedure does not execute. I have admin right on the database and I do not get any error. Just do not get the result I wanted.</p>
  
  <p>Below is the details of the job:</p>
  
  <p><img src="https://i.stack.imgur.com/LjJi5.png" alt="enter image description here"></p>
  
  <p>The creation was successful</p>
  
  <p><img src="https://i.stack.imgur.com/3laBj.png" alt="enter image description here"></p>
  
  <p>The stored procedure is a simple one</p>
  
  <pre><code>create or replace 
  PROCEDURE DELETEBOGUSLETTERRECORDS AS 
  BEGIN
      DELETE FROM BOGUSLETTERS;
      COMMIT;
  END DELETEBOGUSLETTERRECORDS;
  </code></pre>
  
  <p>The procedure was tested outside the scheduler, executed fine and all records in the specified tables were deleted.
  However, that same procedure was not executed properly when it was scheduled. I even had the job run immediately, but after it was run, the records were not deleted. No error whatsoever.</p>
  
  <p>What is the issue? Thanks!  </p>