Re: Oracle Stored Procedures

From: Klaus Zeuch <KZeuch_at_hotmail.com>
Date: Mon, 30 Oct 2000 23:43:44 +0100
Message-ID: <8tktjr$cev$07$1@news.t-online.com>

Please see http://osi.oracle.com/~tkyte/ResultSets/index.html for details - there's also a solution for perl.

Klaus
"Carlos Pereyra" <cpereyra_at_my-deja.com> schrieb im Newsbeitrag news:8tkln8$54o$1_at_nnrp1.deja.com...
> I have searched high and low for the answer to this question.
>
> Can Oracle stored procedures return a result set?
> To clarify: In MS SQL Server and Sybase, you can write a stored
> procedure that behaves just like a standard query returning a record
> set to the executor.
> The Oracle ODBC help documentation references a way to accomplish the
> same result by using ref cursors (?) They include a sample C program
> that shows how to do it. I have tried to emulate the functionality of
> the C program using perl but with no success.
> We have dozens of SQL Server stored procs that do select statements
> that we will need to migrate to Oracle when we switch.
> Any help appreciated.
>
> Carlos.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 30 2000 - 16:43:44 CST