title: Oracle DB: Scheduled job failing with error: ORA-06576: not a valid function or procedure name
body: <p>I am trying to create a scheduled job in Oracle DB, from which, I need to execute a stored procedure.</p>
  <p>I have created the procedure like:</p>
  <pre><code>CREATE OR REPLACE PROCEDURE &quot;delete_old_transactions&quot; AS
  BEGIN
    DELETE from EVENT_JOURNAL where EVENT_JOURNAL.WRITE_TIMESTAMP &lt; (((SYSDATE-CAST(TO_TIMESTAMP_TZ('01-01-1970 00:00:00+00:00', 'DD-MM-YYYY HH24:MI:SS TZH:TZM') as date)) * 24 * 60 * 60 * 1000) - (4 * 24 * 60 * 60 * 1000));
    DELETE from SNAPSHOT where SNAPSHOT.CREATED &lt; (((SYSDATE-CAST(TO_TIMESTAMP_TZ('01-01-1970 00:00:00+00:00', 'DD-MM-YYYY HH24:MI:SS TZH:TZM') as date)) * 24 * 60 * 60 * 1000) - (4 * 24 * 60 * 60 * 1000));
  END;
  
  </code></pre>
  <p>The stored procedure compiles fine and gets created successfully.</p>
  <p>I created the scheduled job like:</p>
  <pre><code>BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
     job_name           =&gt;  'delete_old_transactions_job',
     job_type           =&gt;  'STORED_PROCEDURE',
     start_date         =&gt;  SYSTIMESTAMP,
     enabled            =&gt;  true,
     job_action         =&gt;  'delete_old_transactions',
     repeat_interval    =&gt;  'FREQ=MINUTELY;INTERVAL=2;',
     job_class          =&gt;  'DEFAULT_JOB_CLASS',
     comments           =&gt;  'Job for deleting old transactions.');
  END;
  </code></pre>
  <p>The scheduled job also gets created and is executing after every 2 minutes as desired, but it is failing in the execution and returns an error:</p>
  <blockquote>
  <p>ORA-06576: not a valid function or procedure name.</p>
  </blockquote>