Alter session set current_schema=

hi,


  when i try to create a trigger using

create or replace trigger tmp_trig
after logon on database
declare
v_usr varchar2(30);
v_str varchar2(100);
v_schema varchar2(30);
begin
select TRIM(schema_name)
into v_schema
from user_connections
where TRIM(user_name) = USER
and upper(active) = 'Y';
v_str := 'alter session set current_schema=' || v_schema;
execute immediate v_str;
end;
/



in oracle 9i and 8.1.7 on database logon trigger it works

when i tried on 8.1.5 this trigger does not work

mainly it is not setting
v_str := 'alter session set current_schema=' || v_schema;
execute immediate v_str;



vasusmsAsked:
Who is Participating?
 
ameliamConnect With a Mentor Commented:
I just posted about the same problem and received a response, verified on Metalink, that it is a bug in 8.1.5 that was corrected in 8.1.7.3.  
0
 
FerranCommented:
I gives you any error?

0
All Courses

From novice to tech pro — start learning today.