byomite
asked on
Oracle Reports 6i
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.
Thanks.
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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Force accepted
** Mindphaser - Community Support Moderator **
** Mindphaser - Community Support Moderator **
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept Softchoice's answer.
byomite, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will followup.
Please do not accept this comment as an answer!
EXPERTS: Your input for closing recommendations are REQUESTED.
==========
DanRollins -- EE database cleanup volunteer