Package-support plans?

[Nicklas Karlsson]

Hi,

  (sorry if this has been asked before, "package" gives a lot of hits for
RPMs etc, I couldn't find much on this after 2005 in the lists)

Are there any plans for including Oracle-style packages with
namespace/visibility support at some point or is it just "use schemas"? I
could even live without package-state but I find it frustrating with the
namespace pollution when the application grows.

Thanks in advance,
  Nik

-- 
Nicklas Karlsson, +358 40 5062266
Vaakunatie 10 as 7, 20780 Kaarina

Re: Package-support plans?

[Nicklas Karlsson]

Yes, that it surely one option but is there any grant that can be made on a
function so that it can only be called from within the same schema? Even
then it is a bit cumbersome

On Tue, Nov 20, 2018 at 9:12 AM Thomas Kellerer  wrote:

> Nicklas Karlsson schrieb am 20.11.2018 um 07:32:
> > Are there any plans for including Oracle-style packages with
> > namespace/visibility support at some point or is it just "use
> > schemas"? I could even live without package-state but I find it
> > frustrating with the namespace pollution when the application grows.
> >
>
> If you don't need package-level variables, you could use schemas put
> functions in different namespaces.
>
>   create schema package_one;
>   create function package_one.function_one() as ...;
>
>   create schema package_two;
>   create function package_two.function_two() as ...;
>
>
>
>
>
>
>

-- 
Nicklas Karlsson, +358 40 5062266
Vaakunatie 10 as 7, 20780 Kaarina