Results for DBMS_SESSION


1 to 20 of 88 results. Prev  Next
Results per page:   20  | 40 | 60


Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Using DBMS_SESSIONSecurity Model Operational Notes

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

86 DBMS_SESSIONinformation, from PL/SQL. You can use DBMS_SESSION to set preferences and security levels. This chapter … contains the following topics: Using DBMS_SESSION Security Model Operational Notes Summary of DBMS_SESSION Subprograms

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Summary of DBMS_SESSION SubprogramsTable 86-1  DBMS_SESSION Package Subprograms Subprogram Description CLEAR_CONTEXT Procedure Clears

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Return ValuesThe behavior of this procedure depends upon the configuration of the server operating on behalf of the client: Dedicated server: This returns unused PGA memory and session memory to the operating system. Session memory is allocated from the PGA in this configuration. Shared server: This returns unused session memory to the shared_pool. Session memory is allocated from the shared_pool in this configuration.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ExamplesThis example illustrates the use of DBMS_SESSION.MODIFY_PACKAGE_STATE. Consider a package P with some global state (a cursor c and a number cnt ). When the package is first initialized, the package variable cnt is 0 and the cursor c is CLOSED. Then, in the session, change the value of cnt to 111 and also execute an OPEN operation on the cursor. If you call print_status to display the state of the

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ParametersTable 86-17  SET_SQL_TRACE Procedure Parameters Parameter Description sql_trace TRUE turns tracing on, FALSE turns tracing off.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

SyntaxDBMS_SESSION.SET_IDENTIFIER ( client_id VARCHAR2);

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Return ValuesTable 86-19  UNIQUE_SESSION_ID Function Return Values Return Description unique_session_id Returns up to 24 bytes.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

SyntaxDBMS_SESSION.SET_CONTEXT ( namespace VARCHAR2, attribute VARCHAR2, value VARCHAR2, username VARCHAR2, client_id VARCHAR2 );

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

CLOSE_DATABASE_LINK ProcedureThis procedure closes an open database link. It is equivalent to the following SQL statement: ALTER SESSION CLOSE DATABASE LINK

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

SyntaxDBMS_SESSION.CLOSE_DATABASE_LINK ( dblink VARCHAR2);

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ParametersTable 86-7  IS_SESSION_ALIVE Function Parameters Parameter Description uniqueid Unique ID of the session: This is the same one as returned by UNIQUE_SESSION_ID.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ParametersTable 86-5  IS_ROLE_ENABLED Function Parameters Parameter Description rolename Name of the role.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Return ValuesTable 86-8  IS_SESSION_ALIVE Function Return Values Return Description is_session_alive TRUE or FALSE, depending on whether the session is active.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

SyntaxDBMS_SESSION.RESET_PACKAGE;

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Usage NotesNote the following: For 8i compatibility, only the first three parameters are used. The first three parameters are required for all types of context. The username parameter must be a valid SQL identifier The client_id parameter must be a string of at most 64 bytes. It is case-sensitive and must match the argument provided for set_identifier. If the namespace parameter is a global context namespace,

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ExamplesCREATE OR REPLACE PROCEDURE high_priority_task is old_group varchar2(30); prev_group varchar2(30); curr_user varchar2(30); BEGIN -- switch invoker to privileged consumer group. If we fail to do so, an -- error will be thrown, but the consumer group will not change -- because 'initial_group_on_error' is set to FALSE dbms_session.switch_current_consumer_group('tkrogrp1', old_group, FALSE); -- set up

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ParametersTable 86-4  CLOSE_DATABASE_LINK Procedure Parameters Parameter Description dblink Name of the database link to close.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

CLEAR_IDENTIFIER ProcedureThis procedure removes the set_client_id in the session.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

IS_ROLE_ENABLED FunctionThis function determines if the named role is enabled for this session.


Was this page helpful?