Re: Stored procedure that returns a recordset?
From: Ross McKay <rosko_at_zeta.NOT.THIS.BIT.org.au>
Date: Sun, 17 Aug 2003 13:21:09 +1000
Message-ID: <svstjvodmm6hciqq9fvchi5i0pic805btt_at_4ax.com>
Date: Sun, 17 Aug 2003 13:21:09 +1000
Message-ID: <svstjvodmm6hciqq9fvchi5i0pic805btt_at_4ax.com>
On 16 Aug 2003 12:08:34 -0700, rchin_at_panix.com (Robert C) wrote:
>--- The st. procedure need to be in a package. ---
Oh, and whilst I reckon that packages are the way to go in Oracle, if you prefer, you can define your stored procedures as normal. You will need to create (at least) one package, however, to define a type for the reference cursor.
Personally, I'd put all procedures and functions into packages. But one reason I can think of for not doing that, is if you are using Microsoft tools like Visual Studio .NET, Visual Interdev or (shudder) the Data environment in VB to edit your stored procedures - MS tools don't know what Oracle packages are.
cheers,
Ross.
-- Ross McKay, WebAware Pty Ltd "Since when were you so generously inarticulate?" - Elvis CostelloReceived on Sun Aug 17 2003 - 05:21:09 CEST