Re: How to get multiple row via a stored procedure

If you're using < Oracle 8 then this is not possible. I haven't used Oracle 8 yet, but I thought I heard that
they (Oracle) would start supporting resultsets returned from stored procedures. Maybe other Ora8 users
could fill us in on this mystery.....?....?

Anyway, the closest you could come to duplicating this functionality is using Views instead of Stored Procs.
Access's Queries are hardly considered stored procs, so the Oracle Views should be able to handle any/all of
the old logic and functionality. I think this will be the best you will be able to do......

Good luck,
KP

Price Waterhouse LLP wrote in message
<01bcd813$0cf6a440$eb322299_at_nakhtar.us.pw.com>...
>Hello,
>
>I am developing an application in VC++ and accessing the Oracle database
>via ODBC. I have to access the data via stored procedure. I created a....

>Is this possible at all in Oracle. I have to make my application compatible
>with Access and Oracle. This method does work in Access. Although Access
>stored procedure are Predefined queries.
Received on Thu Oct 16 1997 - 00:00:00 CDT