开发者

Is there any way to namespace PL/SQL packages?

开发者 https://www.devze.com 2023-01-23 12:34 出处:网络
I have several different packages, one for each logical part of my application.Some packages are getting huge but I would like to keep all the procedures/functi开发者_StackOverflow社区ons grouped in s

I have several different packages, one for each logical part of my application. Some packages are getting huge but I would like to keep all the procedures/functi开发者_StackOverflow社区ons grouped in some way rather than breaking them into separate packages. Is there any way to nest, or namespace, my packages?

So if I have MYSCHEMA.PKG_PEOPLE and it has 10 procedures and 10 functions, is there no way that I can for instance move the CRUD procedures to MYSCHEMA.PKG_PEOPLE.CRUD. I want to keep all these items inside of PKG_PEOPLE but I want to further sub-divide them.


Beyond Schema and Package, there is no multi-level namespace handling for PL/SQL packages in Oracle.

Within a package body you can define nested procedures but I would guess this isn't what you need.

I think the closest you'll get is to enforce a naming rule on your packages. For example:

MYSCHEMA.PKG_PEOPLE
MYSCHEMA.PKG_PEOPLE_CRUD
0

精彩评论

暂无评论...
验证码 换一张
取 消