René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_session [Oracle]

Procedures/Functions

clear_all_context

procedure clear_all_context (
 namespace                          in                 varchar2        
);

clear_context

procedure clear_context (
 namespace                          in                 varchar2        ,
 client_id                          in                 varchar2 default,
 attribute                          in                 varchar2 default
);

clear_identifier

procedure clear_identifier (
);
procedure close_database_link (
 dblink                             in                 varchar2        
);

free_unused_user_memory

procedure free_unused_user_memory (
);

is_role_enabled

function is_role_enabled returns boolean (
 rolename                           in                 varchar2        
);

is_session_alive

function is_session_alive returns boolean (
 uniqueid                           in                 varchar2        
);

list_context

procedure list_context (
 list                               of                    table  record,
 lsize                             out                   number        
);

modify_package_state

procedure modify_package_state (
 action_flags                       in           binary_integer        
);

reset_package

procedure reset_package (
);

session_trace_disable

procedure session_trace_disable (
);

session_trace_enable

procedure session_trace_enable (
 waits                              in                  boolean default,
 binds                              in                  boolean default
);

set_close_cached_open_cursors

procedure set_close_cached_open_cursors (
 close_cursors                      in                  boolean        
);

set_context

procedure set_context (
 namespace                          in                 varchar2        ,
 attribute                          in                 varchar2        ,
 value                              in                 varchar2        ,
 username                           in                 varchar2 default,
 client_id                          in                 varchar2 default
);
See also create context.

set_identifier

procedure set_identifier (
 client_id                          in                 varchar2        
);

set_nls

procedure set_nls (
 param                              in                 varchar2        ,
 value                              in                 varchar2        
);

set_role

procedure set_role (
 role_cmd                           in                 varchar2        
);

set_sql_trace

procedure set_sql_trace (
 sql_trace                          in                  boolean        
);

switch_current_consumer_group

procedure switch_current_consumer_group (
 new_consumer_group                 in                 varchar2        ,
 old_consumer_group                out                 varchar2        ,
 initial_group_on_error             in                  boolean        
);

unique_session_id

function unique_session_id returns varchar2 (
);