oracle 上下文 context测试

oracle 上下文 context测试

SQL> select * from V$version;


BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

创建用户：

SQL> create user conuser identified by conuser;

SQL> grant create session,create procedure,create any context to conuser;

注意权限必要是：create any context

一。用户自定义context

会话内的context

conn conuser/conuser

创建context

create context tancon using tanpack;


SQL> create package tanpack as
procedure tancon_value(tancon_v in varchar2);