博客

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);