Re: DDL inside trigger.

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Tue, 8 Jun 2004 00:05:37 +0100
Message-ID: <Co7xc.578$HN2.451@newsfe3-win.server.ntli.net>

"Gama Franco" <gama_franco_at_clix.pt> wrote in message news:40C4EA53.1040102_at_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
>

you can use execute immediate inside a block (but i will question as to why you are doing this) Received on Mon Jun 07 2004 - 18:05:37 CDT