Database Administration (MOSC)

MOSC Banner

dbms_scheduler Error Message

edited Jun 11, 2009 8:34AM in Database Administration (MOSC) 10 commentsAnswered
OS:  Oracle Enterprise Linux 5 Update 2 x86-64 DB:  10.2.0.4.0, Standard Edition

I'm having some trouble with a job I've created via the dbms_scheduler package.  I've looked at the docs and tried creating the job with a couple different options but I'm running into the following error message,

ORA-06550: line ORA-06550: line 1, column 421:
PLS-00302: component 'CANCEL_UNPAID_CCTXFEES' must be declared
ORA-06550: line 1, column 405:
PL/SQL: Statement ignored
, column :

Here is the call to the package I'm using:
BEGIN
dbms_scheduler.create_job (
   job_name           =>  'cancel_unpaid_cctxfees',

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center