Schedule a Procedure with Input Parameters [message #621488] |
Wed, 13 August 2014 14:03 |
|
praveenramaswamy
Messages: 34 Registered: December 2013
|
Member |
|
|
Dear Experts
Need your guidance. I wrote a Stored Procedure that has got 3 Input Parameters as below, which create a TEXT File.
Company Code = C and F
Month = Current Month in Number
Year = Current Year
While i run this procedure manually, I pass the input parameter accordingly and it works. No issues here.
I need to schedule the job to run 15th of each month. While it runs on the 15th, how can i pass the input parameter automatically.
Please assist
Regards
|
|
|
|
Re: Schedule a Procedure with Input Parameters [message #621491 is a reply to message #621490] |
Wed, 13 August 2014 14:15 |
|
praveenramaswamy
Messages: 34 Registered: December 2013
|
Member |
|
|
BlackSwan wrote on Wed, 13 August 2014 14:12how to decide/determine what is correct/desired Company Code?
SQL> select to_char(sysdate,'MM'), to_char(sysdate,'YYYY') from dual;
TO,TO_C
--,----
08,2014
The Procedure ideally will create 2 text files.
First Text File with Input Parameters: Company Code = C, Month = 08, Year = 2014
Second Text File with Input Parameters: Company Code = F, Month = 08, Year = 2014
|
|
|
|