Forum Stats

  • 3,872,750 Users
  • 2,266,466 Discussions
  • 7,911,291 Comments

Discussions

Undroppable trigger

861972
861972 Member Posts: 2
edited May 17, 2011 5:44AM in SQL Developer
Hi people, I have a problem.

I have done a trigger. It simulates an account block.

create or replace
trigger pruebaBloqueo
after logon on database
when (user=XXXXX)
declare
v varchar2(32766);
begin
loop
v:='&a';
end loop;
end;

XXXXX is the target user, absolutely irrelevant for the case.

And the problem? The problem is, I can't neither edit it, nor disable it, nor drop it, nor replace it, because SQLDeveloper crashes, but I need to drop it as soon as possible!

My user: A2172. Obviously, XXXXX is not A2172.

NEW: WHEN I WAIT FOR LONG, I GET ORA-40201 ERROR.

Edited by: 858969 on 15-May-2011 14:29 - Added the error info.
Tagged:

Answers

This discussion has been closed.