Online Documentation for SQL Manager for Oracle

Creating/editing context

Use the Context tab of Context Editor to create/edit a context namespace and specify its properties.



Specify the name of the context namespace to create or modify. Context namespaces are always stored in the SYS schema.


Context Editor - Editing Context definition


Package schema

Use the drop-down list to specify the schema owning package.


Package name

Use the drop-down list to specify the PL/SQL package that sets or resets the context attributes under the namespace for a user session.



Context type

Use this group to specify an entity other than Oracle Database that can initialize the context namespace.


RadioButton Accessed locally

Indicates that the namespace can be accessed locally.


RadioButton Accessed globally

Indicates that any application context set in the namespace is accessible throughout the entire instance. This setting lets multiple sessions share application attributes.


RadioButton Initialized externally

Indicates that the namespace can be initialized using an OCI interface when establishing a session.


RadioButton Initialized globally

Indicates that the namespace can be initialized by the LDAP directory when a global user connects to the database. After the session is established, only the designated PL/SQL package can issue commands to write to any attributes inside the namespace.


To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.