Hi All,
When I compile a package with PLSQL warning enable ALL, I am seeing some warning that don't use global variable in declaration section.
Q: Why we should not do it ?
Q: If not do in in declaration section then where to do ?
Q: Is there any benefit of doing it in Package Initialization section ?
Q: If I initialize a value in Package Initialization section and same package is called parallel 100 times the value will be be initialized only once or in each and every session invoking the package ?
Q: Benefit of Package Initialization section ?