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

I'm not sure but I don't think selecting "what" means a job is running. Even jobs that aren't running are present in dba_jobs table. Maybe I'm misunderstanding something...

• Dc.

On Fri, 09 Jun 2000 07:37:30 GMT, sigdock_at_my-deja.com wrote:

>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