Re: Seeing results of stored procedure

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.

• rajXesh

--

All you need in this life is ignorance and confidence, and then success is sure. -- Mark Twain (1835 - 1910)

Posted via http://dbforums.com Received on Fri Jan 17 2003 - 08:42:17 CST