DBMS_JOB.SUBMIT

From: <NeedaHoliday>
Date: Tue, 22 May 2001 16:20:23 -0400
Message-ID: <59ilgt4rgkmkhvojs3h7s4hbgucjhbovoo_at_4ax.com>

How can I get the following parameters to be populated within the DBMS_JOB.SUBMIT clause.

create or replace procedure submit_jobs

(IN_Inv_Per  CHAR,
 IN_Prj_Id   NUMBER,
 IN_Cust_Id  CHAR)

is
job_num integer;
begin
dbms_job.submit(job_num,
'sp_calc_summary_data(' ' IN_Inv_Per' ',' 'In_Prj_Id' ',

                                      ' ' IN_Cust_Id' ');',

SYSDATE + (10/ (24*60*60)));   IN_Inv_Per, IN_Prj_Id and IN_Cust_Id are not populated with the incoming parameters.

Thanks in advance

James.stewart_at_nospamPWGSC.GC.CA

omit nospam to email. Received on Tue May 22 2001 - 22:20:23 CEST