Job Queue Question
From: <arthur_merar_at_my-deja.com>
Date: Fri, 09 Jul 1999 19:02:42 GMT
Message-ID: <7m5h09$i3a$1_at_nnrp1.deja.com>
PL/SQL: Statement ignored
Date: Fri, 09 Jul 1999 19:02:42 GMT
Message-ID: <7m5h09$i3a$1_at_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 - 21:02:42 CEST