Subject | limit visibility of store procedure |
---|---|
Author | ndirondello marco |
Post date | 2011-04-20T13:10:35Z |
hi all, there's same way to get the equivalent of public/private methods of programming language as java for store procedure?
i need it to clean my databases becouse a lot of times i split big procedures into more simple sub procedure called inside the main procedure (this help to clean the code and simplify debugging/refactoring/etc),
the problem is that i have a long list of procedures with a big percentage of them used only once inside other procedure, so i'm searching a way to hide or split them into logic groups.
also if exist same as namespaces is good for me.
sorry if this is a stupid question but i' not very good in db management.
i need it to clean my databases becouse a lot of times i split big procedures into more simple sub procedure called inside the main procedure (this help to clean the code and simplify debugging/refactoring/etc),
the problem is that i have a long list of procedures with a big percentage of them used only once inside other procedure, so i'm searching a way to hide or split them into logic groups.
also if exist same as namespaces is good for me.
sorry if this is a stupid question but i' not very good in db management.