Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Consequence of renaming table for triggers ?
For the first point OK.
How can you tell us that using a table name in your code is not necessary,
especially if it is about trigger.
How would you code a trigger, fired on an insert, without naming your table
in its body ?. I'm more than interested Mr Bakker.
Regs
Max.
Sybrand Bakker wrote:
> On Sat, 20 Jan 2001 00:23:14 GMT, "M.RAMBELOSON" <MRambeloson_at_free.fr>
> wrote:
>
> >Hi all,
> >
> >Anyone can tell what happen to a trigger defined on a table that has
> >been renamed ?. I met the case, it seems that the old table name remains
> >in the trigger body, but the new one appers in the TABLE_NAME column of
> >the DBA_TRIGGERS dictionary table ...
> >
> >Thanks in advance
> >Max.
> Which is quite logical. Do you a rename expect to 'edit' your pl/sql
> code, which has been stored in a long. I don't think so.
> Also, I'm not sure why you are using the table name in your code.
> Usually that is not necessary.
>
> Regards,
> Sybrand Bakker, Oracle DBA
Received on Mon Jan 22 2001 - 16:30:18 CST