Hi All,
I am new to Impromptu and here is what I need to do.
Before running a report, run an Oracle Stored Proc (which does not require any input or output parameters).
I am trying to do this as a macro but do not know how do I go about doing this.
I have read the threads which explain how stored procs are used in Impromptu but not sure of the following :
1. Can I not just run the already existing database stored procedure by doing a call within this macro?
2. Do I have to go through the CreateStoredProcedure first?
Any help will be highly appreciated.
Thanks,
Ashiish
I am new to Impromptu and here is what I need to do.
Before running a report, run an Oracle Stored Proc (which does not require any input or output parameters).
I am trying to do this as a macro but do not know how do I go about doing this.
I have read the threads which explain how stored procs are used in Impromptu but not sure of the following :
1. Can I not just run the already existing database stored procedure by doing a call within this macro?
2. Do I have to go through the CreateStoredProcedure first?
Any help will be highly appreciated.
Thanks,
Ashiish