I would highly appreciate it if someone can advise me on how to call a stored procedure from reports 6i;
The procedure i am trying to call has 2 IN parameters and 6 OUT parameters.
I tried using a ref cursor but I ran into problems with the return statement in the cursor.
esp. the stored procedure has to return data based on the dates calculated with add_months i.e return groups based on all months for the past 12 months from sysdate.
The problem is when the first date is passed in, the report stops, 'cos of the return statement in the refcur.