title: Oracle XE 10g : Job Scheduling w/in a package or procedure : DBA_SCHEDULER_JOBS
body: <p>I have a package that compiles fine in another 11g environment.<br/>
  When I try to compile it in my XE 10g environment w/ a DBA User, I get the ORA-00942 error.</p>
  
  <pre><code>   FOR r IN (SELECT DISTINCT job_name jname
                          FROM dba_scheduler_jobs
                               ^
                         WHERE job_name LIKE p_job_prefix || '%')
     LOOP
        ...
  </code></pre>
  
  <p>When I execute a direct select on the table there is no issue.<br/></p>
  
  <pre><code>   Select * from dba_scheduler_jobs;
  </code></pre>
  
  <p>Error Text:</p>
  
  <pre><code>   Line: 34 Column: 34  Error: PL/SQL: ORA-00942: table or view does not exist
  </code></pre>