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

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 Thu Nov 18 1999 - 11:44:10 CST