Oracle Stored Procedures

From: Carlos Pereyra <cpereyra_at_pacbell.net>
Date: Mon, 30 Oct 2000 19:38:21 GMT
Message-ID: <8tkind$20l$1_at_nnrp1.deja.com>

[Quoted] [Quoted] 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 - 20:38:21 CET

This message: [ Message body ]
Next message: djsnyder_at_my-deja.com: "Re: Oracle Stored Procedures"
Previous message: Toine Tuerlings: "Re: HELP: pb with a NESTED LOOPS join vs HASH JOIN..."
Next in thread: djsnyder_at_my-deja.com: "Re: Oracle Stored Procedures"
Reply: djsnyder_at_my-deja.com: "Re: Oracle Stored Procedures"
Reply: Harry Joe: "Re: Oracle Stored Procedures"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message