Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Job Queue Question

Job Queue Question

From: <arthur_merar_at_my-deja.com>
Date: Fri, 09 Jul 1999 19:03:21 GMT
Message-ID: <7m5h1g$i3k$1@nnrp1.deja.com>

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. Received on Fri Jul 09 1999 - 14:03:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US