Re: Help! Attack of the Mutant Triggers!

I don't think I can help with your mutating table, but I believe you CAN do DDL from PL/SQL.

I've seen a package in the oracle_home/rdbms/admin directory that appears to do it. I think the name of the package is dbms_ddl.

Note, I have not used this package, nor do I know anyone that has, so I'm not sure if it actually does ddl.

Also, in Oracle 7.2, they're supposed to allow dynamic sql from PL/SQL. You could execute the create table statement via dynamic SQL.

Will Kooiman. Received on Sat Jul 22 1995 - 00:00:00 CEST