Re: Oracle Packages vs PostgreSQL

On 01/12/2017 11:34 AM, Joshua D. Drake wrote:
> Hello,
>
> I recently did a very popular webinar: PostgreSQL for Oracle people.
> Although PostgreSQL can be a replacement for many Oracle
> installations, PostgreSQL doesn't have Oracle style packages.
>
> I was hoping someone on this list could help me understand the primary
> benefits of packages over standard Stored Procedures/UDFs (which
> PostgreSQL does have)?
>
> Sincerely,
>
> Joshua D. Drake

Well, packages make programming much easier. Not only do you keep related procedures together, you can also have private package variables and the package initialization. Also, packages are units of security, so you can grant permissions on the package to the entire group of users and if you later modify the package and add a function, you don't need to grant it separately.

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l