Re: difference between a packaged procedure and a stored procedure/function

Thanks for the elucidation!

One more question, perhaps two? I noticed that the Oracle docs say a function returns a value, but it does not say a procedure does not.

Can a procedure return a value like a function, and can a function have in/out parameters?

Thanks
Jeff

On Thu, 18 Nov 1999 17:44:10 -0000, "James Belton" <jbelton_at_freenetname.co.uk> wrote:

>Jeff,
>
>A stored procedure is stored directly on the database. Indeed, it can return
>values to the calling routines.
>
>A packaged procedure is basically a procedure which resides within a
>package - a package contains many procedures.
>
>For instance, if you have an application and a common area uses a number of
>procedures, it may be easier to package them together rather than have them
>separate. For instance the package might be called UPDATES and contain all
>the packages used in the update routines.It's easier to associate them to an
>area of the application this way.
>
>Also, you can assign execute rights to a package so, it is quicker to assign
>the rights to a package to a user or role, rather than the individual
>procedures.
>
>To access a procedure in a package, the syntax is
>
>execute package_name.procedure('args');
>
>Regards
>
>
>James Belton
>
>
>Jeff Kish wrote in message ...
>>Can someone enlighten me as to the differences (and when you would use
>>one and not the other) between a packaged procedure and a stored
>>procedure/function?
>>
>>I know the stored procedure/function is compiled, and I assume the
>>stored procedure/function can return a value to the calling routine.
>>
>>Thanks so much,
>>
>>trying to educate myself,
>>
>>Jeff
>>
>
Received on Mon Nov 22 1999 - 11:17:56 CST