Re: Trigger Question
From: Heide <heidecarrier_at_oasas.state.ny.us>
Date: 21 Nov 2001 15:53:00 GMT
Message-ID: <1006357852.935417_at_proxy.storm.co.za>
Date: 21 Nov 2001 15:53:00 GMT
Message-ID: <1006357852.935417_at_proxy.storm.co.za>
Have you tried referencing the rowid?
Gerald Gruber wrote:
> Hi!
> I have a table TAB1 with some fields in it. There is a trigger on update of
> field FLDn. In this trigger I want to calculate the number of rows in TAB1
> that have the same value as the triggered row.
> Something like:
> select count(*) into i from tab1 where fld3 := :new.fld3
> in an update trigger won´t work, because the SQL-Statement may not see the
> triggered row.
> Any suggestions to solve my problem?
> Thank you
> Geri
Posted via www.orafocus.com - Focusing on the World of Oracle Received on Wed Nov 21 2001 - 16:53:00 CET