InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Are Global Constructs Declared In Packages Available To The Entire User Session? |
|
Answer» Global constructs once DECLARED in package are available throughout the USER session. Until the user session is terminated, the global construct retains its value across the PL/SQL blocks. This is applicable for all the packaged global constructs, such as constants, exceptions, and cursors. For example, a GLOBALLY declared cursor may be opened in one PL/SQL block, fetched in another block, and CLOSED in some other block. Global constructs once declared in package are available throughout the user session. Until the user session is terminated, the global construct retains its value across the PL/SQL blocks. This is applicable for all the packaged global constructs, such as constants, exceptions, and cursors. For example, a globally declared cursor may be opened in one PL/SQL block, fetched in another block, and closed in some other block. |
|