DDL Trigger not firing -- Why?? [message #19803] |
Wed, 10 April 2002 12:43 |
Kutsal Berberoglu
Messages: 3 Registered: April 2002
|
Junior Member |
|
|
Hi folks..
I'm running Oracle 8.1.7 on Solaris. I've created a DDL trigger in a schema, but that trigger is not firing at all. This is the trigger:
CREATE OR REPLACE TRIGGER test
BEFORE DDL ON SCHEMA
BEGIN
raise_application_error(-20202, 'Yeah, right..');
END;
According to this, any subsequent DDL statement on this Schema should fail with that exception.. But I can happily go ahead and create/drop/alter any table in the schema without any error messages....
What do I need to look for? Why would this happen?
Thanks!!
-Kutsal
|
|
|
|
Re: DDL Trigger not firing -- Why?? [message #19807 is a reply to message #19803] |
Wed, 10 April 2002 13:28 |
Kutsal Berberoglu
Messages: 3 Registered: April 2002
|
Junior Member |
|
|
Here's what happens when I do it:
SQL> CREATE OR REPLACE TRIGGER test BEFORE DDL ON SCHEMA BEGIN raise_application_error(-20202, 'Yeah, right..'); END;
Trigger created.
SQL> CREATE TABLE foo ( id number );
Table created.
SQL> DROP TABLE foo;
Table dropped.
And I cannot figure out why the heck that trigger is not firing.... It's going to drive me insane...
-Kutsal
|
|
|