Re: dbms_job failures

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Mon, 16 Jul 2001 12:46:15 -0700
Message-ID: <3B534487.FF17EC7B@attws.com>

Jim Poe wrote:

> I found the SNP trace logs and this is the error being generated
>
> *** SESSION ID:(9.13895) 2001-07-16 12:01:11.318
> *** 2001-07-16 12:01:11.318
> ORA-12012: error on auto execute of job 61
> ORA-06550: line 1, column 102:
> PLS-00201: identifier 'FIT_DBA.AMS_JOB' must be declared
> ORA-06550: line 1, column 102:
> PL/SQL: Statement ignored
>
> Why would the SNP process have problems resolving the user.package
> qualifier? I'm logged in as user 'FIT' which as stated in the previous
> message, can run the procedure without problems from an anonymous block.
>
> Thanks
>
> --
> Jim Poe (jpoe_at_fulcrumit.com)

The package is not owned by FIT ... it is owned by FIT_DBA. Does FIT have execute rights?

It appears not.

Daniel A. Morgan Received on Mon Jul 16 2001 - 14:46:15 CDT