Re: Job Queue Question

From: Glen Upreti <Glen.Upreti_at_nau.edu>
Date: Fri, 09 Jul 1999 13:19:04 -0700
Message-ID: <37865938.5779DE93@nau.edu>

You may need to have whomever the job is running as have explicit (NOT through a role) privileges to execute that proc. enjoy,
--glen

arthur_merar_at_my-deja.com wrote:
>
> Hello,
>
> I am trying to run a job in the queue. However, after each execution,
> the job becomes broken. Here is the trace/alert file entry:
>
> Fri Jul 9 13:46:26 1999
> *** SESSION ID:(6.6051) 1999.07.09.13.46.26.000
> ORA-12012: error on auto execute of job 36
> ORA-06550: line 1, column 96:
> PLS-00201: identifier 'CASH_MAN.WATER_PUSH' must be declared
> ORA-06550: line 1, column 96:
> PL/SQL: Statement ignored
>
> I cannot even force execute it. WATER_PUSH is the procedure and
> CASH_MAN is the schema.....so I do not understand the problem here.
>
> Can anyone help?
>
> Please cc a copy to my e-mail.
>
> Thanks,
>
> Arthur
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407 Glen.Upreti_at_NOSPAMnau.edu

Received on Fri Jul 09 1999 - 15:19:04 CDT