Translate Microsoft Transact SQL to PL/SQL
From: Bar Orion Barak <barak_at_gandalf.gefen.co.il>
Date: 28 Nov 2000 15:48:42 -0200
Message-ID: <m3itp856o5.fsf_at_gandalf.gefen.co.il>
Date: 28 Nov 2000 15:48:42 -0200
Message-ID: <m3itp856o5.fsf_at_gandalf.gefen.co.il>
Hi.
How do I translate the following Transact SQL to PL/SQL in such way that I will not have to change the the C++ source that call this procedure (using ODBC).
create procedure foo
as
select field1, field2
from sometable
go
(PL/SQL will not let me do select without the into clause)
Thanks,
Barak.
Received on Tue Nov 28 2000 - 18:48:42 CET