Re: TRIGGER in Oracle 7

The format of a field you can't change indeed ! What you can do is change the value of some fields by using 'new.column_name = new_value'

Good luck

Jürgen

<djamelg_at_my-deja.com> wrote in message news:87c9f5$gdq$1_at_nnrp1.deja.com...
> Please,
>
> I want to do a trigger which modify a format of some fields when
> updating or inserting. With the insertion, no problem. But when I
> update my table, the system send me : "table is mutating,
> trigger/function may not see it " ?
>
> Thank you
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 04 2000 - 02:50:02 CST