How To DO? Stored procedures that return result sets.
From: Alex de Gaston <degaston_at_netwave.net>
Date: Thu, 12 Nov 1998 06:22:05 -0600
Message-ID: <364AD2ED.235533A6_at_netwave.net>
In Sybase I can write a stored procedure that will do the following:
Date: Thu, 12 Nov 1998 06:22:05 -0600
Message-ID: <364AD2ED.235533A6_at_netwave.net>
In Sybase I can write a stored procedure that will do the following:
create procedure sp_mytest as
select * from emp where salary<50000
return 0
The application calling the stored procedure will receive a result set with all employees making less than $50K.
Is there any guide out there that can tell me how to do the same thing in Oracle? Received on Thu Nov 12 1998 - 13:22:05 CET