submit request with parameters

[vamsioracle]

Hi


I have a procedure that i need to schedule to run. I created a concurrent program for that. But the procedure has four parameters. I need to call this concurrent program from one more procedure where the values are retrieved.

create or replace procedure cbtt_update(fromname IN Varchar2, sender IN varchar2, begindate IN date, enddate IN varchar2)
is
begin
..............

Business logic
...........

end cbtt_update

I created a concurrent program cbttupdate for the above code. Now i have one more procedure which calls this concurrent program and also the parent procedure for getting the parameter values.

create or replace procedure cbtt_getvalues()
is
fromname varchar2(100);
sender varchar2(100);
begindate date;
enddate date;
conreqid number :=0;
begin

select creator_id,selector,begin_date,end_date into fromname,sender,begindate,enddate from table where..................

concreqid :=  fnd_request.submit_request ('FND',cbttupdate,'',SYSDATE,FALSE,CHR (0));

end cbtt_getvalues;

Now the above request wil just cal the procedure. Where should i add the parameters. Is this the right way to call.

concreqid := fnd_request.sub mit_request ('FND',cbttupda te,'',SYSDATE,F ALSE,CHR (0),fromname,se nder,begindate, enddate);

vamsi

[debasisdas]

If you want to schedule it then use DBMS_JOB for the purpose.

[vamsioracle]

Thanks Debasisdas,

DBMS_JOB worked for me.

thanks alot

vamsi

[vamsioracle]

hi debasisdas

suddenly when i changd scheduled one more procedure i get this error

PLS-00222: no function with the name cbtt_reminder exists in this scope. The procedure is compiled.]


vamsi

[vamsioracle]

This is my code:

dbms_job.submit (job => jobid, what =>cbtt_reminder (fromname,tonam e,begindate),ne xt_date => begin_date);

I am calling this in my first procedure.

vamsi