Schema Level Trigger difficulties

From: ChrisH <chris_hughes22_at_yahoo.co.uk>
Date: 12 Jul 2005 08:10:49 -0700
Message-ID: <1121181049.769006.288420@g47g2000cwa.googlegroups.com>

Hi all.

I was wondering if any body had a solution to the following.

I have a schema level trigger....
....

AFTER CREATE ON SCHEMA
......

CreateMyTableLevelTrigger(mytable);
END; Problem is when I create a table the procedure executes, when this procedute tries to CREATE the trigger for the new table Oracle tries to run the SCHEMA trigger again.

Is there a way I can only run this schema trigger for tables?? Is the a way to create the table trigger without firing the schem trigger??

Thanks in advance. Received on Tue Jul 12 2005 - 10:10:49 CDT