Stored procedure that returns a recordset?
From: Gene Frassetto <efrassetto_at_comcast.net>
Date: Fri, 15 Aug 2003 11:54:44 -0400
Message-ID: <s22dnUIMA7mdn6CiXTWJkQ_at_comcast.com>
I have a VB program that calls stored procedures in MS SQL Server that deliver a recordset. I need to do the same thing with Oracle. Following is a simple SQL Server procedure that does this. How do I do that with Oracle?
END return (0)
Date: Fri, 15 Aug 2003 11:54:44 -0400
Message-ID: <s22dnUIMA7mdn6CiXTWJkQ_at_comcast.com>
I have a VB program that calls stored procedures in MS SQL Server that deliver a recordset. I need to do the same thing with Oracle. Following is a simple SQL Server procedure that does this. How do I do that with Oracle?
CREATE PROCEDURE dbo.sp_Level1
_at_ClientDB varchar (30) = NULL,
_at_LevelID1 varchar (8) = NULL
AS
BEGIN
Select * from tblLevel1
END return (0)
END Received on Fri Aug 15 2003 - 17:54:44 CEST