Oracle Database Creating a Context

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Insert
> Step 2: And Like the video. BONUS: You can also share it!

Syntax

  • CREATE [OR REPLACE] CONTEXT namespace USING [schema.]package;
  • CREATE [OR REPLACE] CONTEXT namespace USING [schema.]package INITIALIZED EXTERNALLY;
  • CREATE [OR REPLACE] CONTEXT namespace USING [schema.]package INITIALIZED GLOBALLY;
  • CREATE [OR REPLACE] CONTEXT namespace USING [schema.]package ACCESSED GLOBALLY;

Parameters

ParameterDetails
OR REPLACERedefine an existing context namespace
namespaceName of the context - this is the namespace for calls to SYS_CONTEXT
schemaOwner of the package
packageDatabase package that sets or resets the context attributes. Note: the database package doesn't have to exist in order to create the context.
INITIALIZEDSpecify an entity other than Oracle Database that can set the context.
EXTERNALLYAllow the OCI interface to initialize the context.
GLOBALLYAllow the LDAP directory to initialize the context when establishing the session.
ACCESSED GLOBALLYAllow the context to be accessible throughout the entire instance - multiple sessions can share the attribute values as long as they have the same Client ID.

Remarks



Got any Oracle Database Question?