Groups > comp.databases.oracle.misc > #830

Re: capturing DDL change with a trigger

From	geos <geos@SPAMPRECZ.autograf.pl>
Newsgroups	comp.databases.oracle.misc
Subject	Re: capturing DDL change with a trigger
Date	2014-04-02 22:41 +0200
Organization	CI TASK http://www.task.gda.pl/
Message-ID	<lhhsli$6tg$1@news.task.gda.pl> (permalink)
References	<lhhmpa$u0i$1@news.task.gda.pl> <533c73ac$0$2232$426a74cc@news.free.fr>

Show all headers | View raw

On 02.04.2014 22:31, Michel Cadot wrote:

> Your "when others clause is just silly.
> Remove it.
> Read http://www.orafaq.com/wiki/WHEN_OTHERS

Thanks, this is secondary issue for me now, I'll correct it later on. Do 
you know why the trigger doesn't store the DDL code "after alter" statement?

thank you,
geos

Back to comp.databases.oracle.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

capturing DDL change with a trigger geos <geos@SPAMPRECZ.autograf.pl> - 2014-04-02 21:01 +0200
  Re: capturing DDL change with a trigger "Michel Cadot" <micadot{at}altern{dot}org> - 2014-04-02 22:31 +0200
    Re: capturing DDL change with a trigger geos <geos@SPAMPRECZ.autograf.pl> - 2014-04-02 22:41 +0200
  Re: capturing DDL change with a trigger ddf <oratune@msn.com> - 2014-04-03 07:48 -0700
    Re: capturing DDL change with a trigger geos <geos@SPAMPRECZ.autograf.pl> - 2014-04-03 19:00 +0200
      Re: capturing DDL change with a trigger ddf <oratune@msn.com> - 2014-04-07 07:51 -0700
        Re: capturing DDL change with a trigger geos <geos@SPAMPRECZ.autograf.pl> - 2014-04-08 13:33 +0200
        Re: capturing DDL change with a trigger joel garry <joel-garry@home.com> - 2014-04-08 14:03 -0700
          Re: capturing DDL change with a trigger ddf <oratune@msn.com> - 2014-04-10 07:09 -0700
  Re: capturing DDL change with a trigger fvillasa@gmail.com - 2017-01-18 14:41 -0800

csiph-web