Re: Can I get recordset from Oracle stored procedure like it in MS SQL ?

No. Unfortunately, Stored Procedure in Oracle does not support this feature. What you may have to do is populate an answer table from within the stored procedure and then query it from the client program. The absence of temporary tables (as in MS SQL Server/Sybase) makes it a little more tricky. One method I have used in the past is:

1. Create a sequence.
2. Generate the next value of the sequence.
3. Have a column for the sequence in the answer table.
4. Use the sequence while populating the answer table.
5. Select * from answer table where sequence = Your sequence.

Since Oracle sequences are guaranteed to be unique, this method will work. Let me know if this was of any help to you. Good luck,

Murali Kazhipurath
Oracle DBA

End User wrote in message <01bd0a93$addfd680$0100a8c0_at_intres>...
>HI!
>Can I get recordset from Oracle stored procedure like it in MS SQL ?
>Thanks for answers, Oleg Tkachenko
>email : tkachenko_at_intresys.com
>
>
Received on Wed Dec 17 1997 - 00:00:00 CST