Translation from MSSQL to PL/SQL
From: Bar Orion Barak <barak_at_gandalf.gefen.co.il>
Date: 27 Nov 2000 21:48:59 -0200
Message-ID: <m3lmu55638.fsf_at_gandalf.gefen.co.il>
Date: 27 Nov 2000 21:48:59 -0200
Message-ID: <m3lmu55638.fsf_at_gandalf.gefen.co.il>
hi,
I need to translate the following MSSQL store procedure to PL/SQL.
CREATE PROCEDURE pr_GetDistinctUsers
AS
select a, b
from sometable;
go
When working with ODBC I will get the dataset a result of calling this store procedure from C.
PL/SQL will not let me do a select unless I will use the INTO clause. How can I translate the following store procedure to PL/SQL without have to change my C code ?
Thanks. Received on Tue Nov 28 2000 - 00:48:59 CET