RE: A lazy connection!

From: Naik, Sandesh S <sandesh.naik_at_qwest.com>
Date: Mon, 23 Jul 2001 10:14:25 -0700
Message-ID: <F001.003520EC.20010723101252@fatcity.com>

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: sandesh.naik_at_qwest.com

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: ListGuru_at_fatcity.com (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). Received on Mon Jul 23 2001 - 12:14:25 CDT