Triggers and DDL

I am writing a trigger that fires after insert. I want to use the information inserted to create a temporary table. I was thinking of using the dbms_sql package but when using DDL with dbms_sql it does an implied commit after the prepare executes the statement but commits are not allowed in triggers. Is there another way to accomplish what I want.

Thanks,

Mark Received on Wed Dec 08 1999 - 11:13:52 CST