开发者

Is there any way to namespace PL/SQL packages?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜