PLS-00201: identifier 'SYS.DBA_JOBS' must be declared

Hi all,

In a package procedure I am trying to find out, what specific jobs are currently running.

In SQL*Plus it works really good:

    select count(what) from dba_jobs;

But if I try this query in a package enviroment then I get the following error:

    733/39 PLS-00201: identifier 'SYS.DBA_JOBS' must be declared

    733/3 PL/SQL: SQL Statement

This is the funcion calling sys.dba_jobs (cut & paste from SQL*Worksheet):

727> function TestAuswImportTimerIsRunning return BOOLEAN is

728>

729> nCount INTEGER;

730>

731> begin

732>

733> select count(what) into nCount from dba_jobs where what = PROC_ON_TIMER; 734>

735> if nCount > 0 then

736> return true; -- Timer IS running

737> else

738> return false; -- Timer is NOT running

739> end if;

740>

741> return false;

742> end; -- TestAuswImportTimerIsRunning

PROC_ON_TIMER is a constant string.

Thanks for any help

Eckart´

--


--------------------------------------------------------

DCS  Dialog Communication Systems AG

Dipl.-Inf. Eckart Schultz
Entwicklung                        Cicerostrasse 21
Fon:   +49 (0) 30 / 896 86-542     D-10709 Berlin
Fax:   +49 (0) 30 / 896 86-997     mailto:e.schultz_at_bioid.com
                                   http://www.dcs.de


--------------------------------------------------------

Authenticated or encrypted eMail on request
PGP Key ID: 0x2D0429CC