Re: DBMS_JOB.SUBMIT

Define stored procedure 'sp_calc_summary_data' with parms default null. check them coming into your submit_jobs if null then dbms_jobs.submit('sp_calc_summary_data;',sysdate+1-/24*60*60 ))); without the input parms otherwise use parameter call.

<NeedaHoliday> wrote in message
news: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 Sat Jul 21 2001 - 23:42:37 CEST