Creating Virtual Private application context
An application context is a name-value pair, which Oracle stores in memory. These name-value pairs exist within a namespace. The application context is a global variable, which can be accessed within a database session. Application contexts can support database sessions (user database sessions) and global application contexts (for sessionless models—for example, web applications using session pooling or multi-tiered applications).
Getting ready
Log on to SQL Developer under the schema owner to create the packages for the application context.
How to do it...
Application context is a way to create variables that can be reused within the Oracle database:
- Create a package to set application contexts:
create ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
