what is the disadvantage of package?
-
-
When any packaged function is accessed thru SQL select statement , then Purity level of the function may not be ensured .
But there is a way to avoid this shortcoming -> Pragma RESTRICT_REFERE NCE . -
If you have only one object to execute which is in the package, having 50 objets. So the package will complile fully (Total 50 objects) which is not at all usefull for your requirement.
This is one of the Disadvantage.
MallikComment
Comment