Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored procedures from SQL Server
Martyn J Reason wrote in message <35066F9A.2DBF_at_btlip04.bt.co.uk>...
>Your options are:
>1) include OUT parameter(s).
>
>If you need to return multiple rows of data at a time, you will need to
>set up an ARRAY type variable (TABLE OF <ORACLE type>) e.g
>TYPE num_array IS TABLE OF NUMBER...
>
>2) change the procedure to a function and return data that way
>
>Martyn
I need to return multiple rows of data. This Stored Procedure is executed as part of an open for a MFC recordset, and I would like to not have to make code changes.
Does this mean that I would need to define a table for every column in my database table, and have those as OUT paramaters?
Thanks for the help. Received on Thu Mar 12 1998 - 00:00:00 CST
![]() |
![]() |