Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How bypass a trigger?

Mr.D.Jun 23 2015 — edited Jun 25 2015

In our database tables there are many triggers, about 5 for a single table.

Ok, it's not the best and I've already fight for this.

So now the requirement is to update without fire some triggers.

To do this developer modify triggers adding the select from v$session

DECLARE

sinfo VARCHAR2(200);

BEGIN

Select Client_Info into sinfoFrom V$SESSION Where AudSid = UserEnv('SESSIONID');

If InStr(Coalesce(sinfo, 'X'), '*NOTRIGGER*' ) = 0 then

.....

END IF;

END;

and then execute the update procedure doing this before:

DBMS_APPLICATION_INFO.Set_Client_Info ('*NOTRIGGER*');


so every time the trigger fire, query from v$session is performed with high impact on performance.

Is there any other method to bypass a trigger for some program or users?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2015
Added on Jun 23 2015
16 comments
5,213 views