CREATE CONTEXT

Create a set of attributes for use by application logic to validate and secure an application.

Syntax:

   CREATE [OR REPLACE] CONTEXT namespace
     [USING] [schema.]package
        INITIALIZED {EXTERNALLY|GLOBALLY} | ACCESSED GLOBALLY


namespace is the name of the context namespace to create or modify.

The ACCESSED GLOBALLY clause allows multiple sessions to share application attributes. i.e Any application context set in namespace is accessible throughout the entire instance.

“Think global, act local” - Roberto Goizueta (Coca Cola CEO)

Related Oracle Commands:

CONTEXT - DROP CONTEXT
DBMS_SESSION.set_context - Procedure to set current context
SYS_CONTEXT - Function to return context attributes

Related Views:

DBA_CONTEXT        ALL_CONTEXT


 
Copyright © 1999-2024 SS64.com
Some rights reserved