Dear List,
I have a package which I want to execute using dba_jobs.
Within that package I run procedure which has one OUT parameter ( errno)
When I submit the job
declare
jobno number;
errno number;
begin
dbms_job.submit(jobno,'l_load_weekly_aps.p_load_ocn(:errno);',sysda
te,'sysdate');
end;
It submits fine but when I try to run that job
using exec dbms_job.run(52), it gives me following error.
*
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 394
ORA-06512: at "SYS.DBMS_JOB", line 267
ORA-06512: at line 1
ORA-12012: error on auto execute of job 52
ORA-01008: not all variables bound
Anybody has any answers ?
thanks for your help.
Sandesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naik, Sandesh S
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
