prog:sql_oracle_context_object
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
prog:sql_oracle_context_object [2016/09/08 18:28] – angelegt gpipperr | prog:sql_oracle_context_object [2016/09/08 18:29] (aktuell) – [Das Oracle CONTEXT Object - Globale Werte in einer Session hinterlegen] gpipperr | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | ===== Das Oracle CONTEXT Object - Globale Werte in einer Session hinterlegen===== | ||
+ | |||
+ | Aufgaben: | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ===Rechte vergeben=== | ||
+ | |||
+ | Als SYS User: | ||
+ | |||
+ | <code sql> | ||
+ | GRANT CREATE ANY CONTEXT TO GPI; | ||
+ | </ | ||
+ | |||
+ | |||
+ | === Context anlegen === | ||
+ | |||
+ | <code sql> | ||
+ | CREATE or replace CONTEXT GPI_MON USING gpi.ADMIN_ENV; | ||
+ | </ | ||
+ | Das Package um den Context zu setzen muss zu diesem Zeitpunkt noch nicht exisiteren | ||
+ | |||
+ | |||
+ | === Context über Package setzen == | ||
+ | |||
+ | Package anlegen | ||
+ | <code sql> | ||
+ | |||
+ | create or replace package admin_env | ||
+ | as | ||
+ | | ||
+ | end admin_env; | ||
+ | |||
+ | create or replace package body admin_env | ||
+ | as | ||
+ | | ||
+ | is | ||
+ | begin | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | end setcontext; | ||
+ | end admin_env; | ||
+ | </ | ||
+ | |||
+ | === Context über Package setzen == | ||
+ | |||
+ | Setzen: | ||
+ | <code sql> | ||
+ | begin | ||
+ | ADMIN_ENV.setContext; | ||
+ | end; | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | Abfrage: | ||
+ | <code sql> | ||
+ | select sys_context(' | ||
+ | </ | ||
+ | |||
+ | ==== Quellen ==== | ||
+ | |||
+ | SQL Doku => http:// | ||
+ | |||
+ | Beispiel => https:// | ||
prog/sql_oracle_context_object.txt · Zuletzt geändert: 2016/09/08 18:29 von gpipperr