Re: Seeing results of stored procedure

On Fri, 17 Jan 2003 14:42:17 +0000, rajXesh <member11038_at_dbforums.com> wrote:

>
>Heres whats going on
>
>facility_out_rec is not a out parameter therefore pouplating it is of no
>use. Your out parameter is: facility_out_cur.
>
>You are not populating the your out parameter 'facility_out_cur'
>anywhere in your procedure.
>
>There is no need to declare the cursor, just open it. Just having it
>as an out parameter is sufficient. There is also no need to fetch from
>it. The program calling your procedure will fetch from it and close
>the cursor.
>
>Study the examples that Dan Morgan or Tom Kyte have provided. Those
>should give you a better idea of what's what.
>

Yes, I finally got this working, thanks to you guys. I'll try to do better next time!

Thanks,
Harry Received on Fri Jan 17 2003 - 12:00:37 CST