title: Call a Procedure with parametes through DBMS_JOB.SUBMIT
body: <p>I am working on Oracle 11gR1</p>
  
  <p>I have to call a procedure which accepts a CLOB as input parameter through a DBMS_JOB.SUBMIT procedure.</p>
  
  <p>Here is my code for the same:</p>
  
  <pre><code>FOR i IN 1 .. lrec_resultset.COUNT LOOP
  
                      DBMS_JOB.SUBMIT (
                      JOB =&gt; job_num,
                      WHAT =&gt; 'execute_dsql('' ||lrec_resultset(i).sql_txt || '');');
  COMMIT:
  END LOOP;
  </code></pre>
  
  <p>The call to execute_dsql is not being made. I am not even getting any error message when I execute my PL/SQL block which contains this DBMS_JOB call.</p>
  
  <p>Can someone point me in the right direction?</p>