select to_char(sysdate-7,‘MM/DD/YYYY’) from dual
Hi I am trying to call oracle Procedure using automation but its not working.
Its a valid procedure.
Please find the attached scripts which might will help you to provide the solution.
I am facing two issue.
Unable to Call Procedure.
I used Execute script activity to give a call to the procedure.
Used follwoing SQL code to call the procedure.
2. Varible is not set to correct value.
I am trying to assign value using SQL query to a Variable VAR_DATE.
But the value is not correct.
Query used to assign value to variable is
I am expecting the varible value as 12/08/2010
It will be great if you are able to provide any suggestion/help.
If you find some information missing please write me.
AutmateProcedure.zip (156 KB)