Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help me I'm mutating and I don't even know it!

Re: Please help me I'm mutating and I don't even know it!

From: Gjlinker <gjlinker_at_aol.com>
Date: 21 Feb 1999 00:11:06 GMT
Message-ID: <19990220191106.07007.00000371@ngol06.aol.com>

Dear all,

Check the table you update for row triggers (for each row). Each of these triggers may not refer to or change columns in the table you change nor they may change foreign key columns in other tables.

Alternatively, if the update is initiated by a trigger, try to find out whether the tables that trigger updates as the same story applies there.

Regards Gerrit-Jan Linker,



*| Gerrit-Jan Linker : gjlinker_at_aol.com
*|
*| http://members.aol.com/gjlinker
*|
*| Developer of:
*| Oraxcel, OraWeb, OraSQL, OraCodes and OraDebug

LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT

LLLL
LLLLLLLLLLLLLLLLLLLLLLLLLLLL

L Linker IT Consulting Ltd L
LLLLLLLLLLLLLLLLLLLLLLLLLLLL

Received on Sat Feb 20 1999 - 18:11:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US