Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database trigger on AFTER UPDATE with Procedure Bldr.
In article <01be3072$0cff1040$LocalHost_at_viao1.camk.com>,
"Andy Hardy" <aph_at_ahardy.demon.co.uk> wrote:
> Sounds like your query to the second table is bringing back more than one
> row of data - your code excerpt doesn't seem to include a where clause.
>
> Also, if you are just trying to replace a column value as the row is
> inserted/updated you should be doing something like ':new.col1 :=
> my_replacement_value' - you seem to be trying to insert a new row into
> table1??
>
> Andy
>
I tried a WHERE clause to limit the select statement to a single row
(Where table2.entry_id = :old.table1.entry_id) however, that gives me an error
message that table1 is mutating, and does not complete the update. Thanks.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Dec 26 1998 - 17:03:15 CST