Alter session set current_schema=

Posted on 2003-03-17
Medium Priority
Last Modified: 2007-12-19

  when i try to create a trigger using

create or replace trigger tmp_trig
after logon on database
v_usr varchar2(30);
v_str varchar2(100);
v_schema varchar2(30);
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;

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;

Question by:vasusms
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 8158657
I gives you any error?


Accepted Solution

ameliam earned 80 total points
ID: 10688959
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  

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question