Re: sql server stored procedure to oracle

"ping" <ping_at_nospam.com> wrote in message news:<b00fsk$j1u$1_at_reader1.imaginet.fr>...
> Hi Actualy migrating stored procedures from sql server 2000 to oracle 9i
>
> 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

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

FALSE!!!!!!!!!!!!!!!!

Look up REF CURSOR in your pl/sql documentation

And PLEASE don't follow your fellow sqlserver morons by never reading manuals and posting incorrect statements in Oracle forums.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Jan 14 2003 - 15:35:10 CET