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

Did you grant the required select-priviliges to the sys.dba_jobs table and maybe you need to create a public synonym to dba_jobs as well. Both as user sys of course.

h.t.h.

In article <8hpbab$3jssk$1_at_fu-berlin.de>,   "Eckart Schultz" <eckart.schultz_at_gmx.de> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 09 2000 - 00:00:00 CDT