Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored procedures from SQL Server

Re: Stored procedures from SQL Server

From: Doug Needham <DNeedham_at_mccorp.com>
Date: 1998/03/12
Message-ID: <6e67u3$26f$1@usenet48.supernews.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US