Re: Simple Procedure Select into an ADO recordset

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 12 Jul 2001 20:37:04 +0200
Message-ID: <tkrreka6bo3ncb@beta-news.demon.nl>

"Joe Carr" <nospam_at_nope.com> wrote in message news:MPG.15b7a5d173386ad2989695_at_news.bellatlantic.net...
> I have a simple issue that is simply driving me nuts.
> All I want to do is write a simple Stored Procedure in Oracle 8i. This
> procedure will do nothing but SELECT * FROM table_name;
> The this procedure will be ran through VB/ADO and it's results stored
> into a recordset. SQLServer, no problem, I can't seem to get Oracle to do
> the same. Can anyone help?
> Thank you.
>
> Joe

This issue has been answered very frequently in this group. Please search the archives at www.google.com using the words "resultset" or "REF CURSOR" Regards,

Sybrand Bakker, Senior Oracle DBA Received on Thu Jul 12 2001 - 13:37:04 CDT