sql server stored procedure to oracle

From: ping <ping_at_nospam.com>
Date: Tue, 14 Jan 2003 09:15:07 +0100
Message-ID: <b00fsk$j1u$1_at_reader1.imaginet.fr>

[Quoted] [Quoted] Hi Actualy migrating stored procedures from sql server 2000 to oracle 9i

[Quoted] The main differance betwwen SQL server & Oracle stored procedure is that Oracle's SP can't return a result set

What is the best way to create an oracle object that could return a row set, I don't even know what kind of object can do this

exemple of a simple sql server sp I need to convert to an oracle object:

CREATE PROCEDURE getlist _at_ID int
AS

BEGIN
 SELECT DISTINCT name
 FROM list
 WHERE (id = _at_ID)
 ORDER BY name
END
GO

Thank's for you help

David Received on Tue Jan 14 2003 - 09:15:07 CET