1,SET_CONTEXT procedure
Sets or resets the value of a context attribute.
Syntax
DBMS_SESSION.SET_CONTEXT (
namespace VARCHAR2,
attribute VARCHAR2,
value VARCHAR2);
Parameters
namespace
The namespace of the application context to be set
attribute
The attribute of the application context to be set
value
The value of the application context to be set
2,SET_CLOSE_CACHED_OPEN_CURSORS procedure
Turns close_cached_open_cursors on or off.
This procedure turns close_cached_open_cursors on or off. It is equivalent to the following SQL statement:
ALTER SESSION SET CLOSE_CACHED_OPEN_CURSORS ...
Syntax
DBMS_SESSION.SET_CLOSE_CACHED_OPEN_CURSORS (
close_cursors BOOLEAN);
Parameters
close_cursors
TRUE or FALSE
Sets or resets the value of a context attribute.
Syntax
DBMS_SESSION.SET_CONTEXT (
namespace VARCHAR2,
attribute VARCHAR2,
value VARCHAR2);
Parameters
namespace
The namespace of the application context to be set
attribute
The attribute of the application context to be set
value
The value of the application context to be set
2,SET_CLOSE_CACHED_OPEN_CURSORS procedure
Turns close_cached_open_cursors on or off.
This procedure turns close_cached_open_cursors on or off. It is equivalent to the following SQL statement:
ALTER SESSION SET CLOSE_CACHED_OPEN_CURSORS ...
Syntax
DBMS_SESSION.SET_CLOSE_CACHED_OPEN_CURSORS (
close_cursors BOOLEAN);
Parameters
close_cursors
TRUE or FALSE
其中
NAME SPACE 应用过程上下文的命名空间
ATTRIBUTE 设置应用程序的上下文
VALUE 是应用程序上下文的值
USERNAME 应用程序上下文中用户名
CLIENT ID 应用程序客户ID号(最大64字节)
哥们儿,只有授权的包才能直接或间接地调用这个冬冬,还有只能在全局性地命名空间上使用。。
为什么用这个冬冬?高手啊!我没有用过。多多交流一下。