Calls
-
PROCEDURE DBMS_SESSION.CLEAR_IDENTIFIER; Removes the value of the session’s client ID. New with Oracle9i.
-
PROCEDURE DBMS_SESSION.CLOSE_DATABASE_LINK(dblinkIN VARCHAR2); Closes the database link dblink or raises an exception if dblink is not open or is in use.
-
PROCEDURE DBMS_SESSION.FREE_UNUSED_USER_MEMORY; Releases freeable session memory back to the operating system (for a dedicated connection) or the Oracle shared pool (for a Shared Server connection).
-
FUNCTION DBMS_SESSION.IS_ROLE_ENABLED(rolenameIN VARCHAR2)RETURN BOOLEAN; Returns TRUE if the rolename is currently enabled in the session.
-
FUNCTION DBMS_SESSION.IS_SESSION_ALIVE(uniqueidIN VARCHAR2)RETURN BOOLEAN; Returns TRUE if the session identified by uniqueid is still alive. New with Oracle8i.
-
PROCEDURE DBMS_SESSION.LIST_CONTEXT(listOUR AppCtxTabTyp,sizeOUT NUMBER); Returns information about the current context in a table of AppCtxTabType. size is the number of entries returned in the buffer. New with Oracle8i.
-
PROCEDURE DBMS_SESSION.MODIFY_PACKAGE_STATE(action_flagsIN PLS_INTEGER); Modifies the package state either with FREE_ALL_RESOURCES, which frees all memory associated with the previously run PL/SQL programs, clears the value of package globals, and closes cached cursors, or with REINITIALIZE, which reinitializes packages and reuses package memory. New with Oracle9i.
-
PROCEDURE DBMS_SESSION.LIST_CONTEXT(listOUT AppCtxTabTyp,sizeOUT NUMBER); Returns a list of namespaces, attributes, and values ...