I am using ActiveReports 11 and need to call an Oracle stored procedure with parameters and return result in a RefCursor. I have search the forum and did not find any clear instruction on what is needed to call an Oracle stored procedure. I have create a simple stored procedure and tested it with Oracle SQL developer tool. Could someone give me instruction on how to setup ActiveReport under the DataSource and DataSet section that is equivalent to the call below that I have test that works in Oracle SQL Developer?
Thanks for any help you may provide.
var c refcursor;
execute MyStoredProc( sysdate()-1,sysdate(), :c)