Re: DDL inside trigger.

Gama_Franco_at_clix.pt (Gama Franco) wrote in message news:<79d09fb0.0406080125.6c992671_at_posting.google.com>...
> "Dave" <david.sharples3_at_ntlXworld.com> wrote in message news:<Co7xc.578$HN2.451_at_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)
>
> Hi,
>
> Thank you for your ansewer, but can you be more specific?
>
> The idea is to have the same users in all the destributed databases. I
> would like to detect the creation of an user in a Node and register
> that user in the other Nodes of the system.
>
> Best regards,
> Gama Franco

If you implement Oracle Internet Directory you can use the Single Signon Mechanism and you don't have to resort to the flaky procedures above.
Also: does it really need to be realtine? Frankly I don't think so. A nightly stored procedure would do. But as Oracle Internet Directory is a better alternative I would hesitate to write my own replication mechanism.

Sybrand Bakker
Senior Oracle DBA Received on Tue Jun 08 2004 - 08:28:12 CDT