Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DDL inside trigger.

DDL inside trigger.

From: Gama Franco <gama_franco_at_clix.pt>
Date: Mon, 07 Jun 2004 23:21:07 +0100
Message-ID: <40C4EA53.1040102@clix.pt>


Dear all,

I'm developing a distributed application using Oracle 9i and I need to use DDL inside a trigger. I've read that it isn't possible, but I believe that there must be another way to solve this situation.

My idea is to create a trigger on a table that detects insertions and creates users in the local and remote databases.

Best regards,

   Gama Franco Received on Mon Jun 07 2004 - 17:21:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US