Re: DDL inside trigger.

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 7 Jun 2004 19:43:36 -0700
Message-ID: <73e20c6c.0406071843.ebf858a@posting.google.com>

Gama Franco <gama_franco_at_clix.pt> wrote in message news:<40C4EA53.1040102_at_clix.pt>...

> 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.

Sure there is.

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

You could for example start a batch (asynch) job that would do that? I believe you can start one via trigger. There will of course be other options.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Mon Jun 07 2004 - 21:43:36 CDT