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:

1. 1. Create a package to set application contexts:

   create package context_package as
   procedure name_value(n varchar2, v varchar2);
   end;
   create package body context_package as
   procedure name_value(n varchar2, v varchar2) as
   begin
   -- can only be called within the package to which it belongs
   -- If you try...