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

Home -> Community -> Usenet -> c.d.o.server -> Trigger for cascading deletes failing

Trigger for cascading deletes failing

From: Hello <Hello_at_yahoo.com>
Date: 2000/03/07
Message-ID: <38C54FA1.75B200C8@yahoo.com>#1/1

Running Oracle 8.0.5.2 on Solaris 2.7

I am trying to implement a trigger given to me by developers that does cascading deletes.
When testing through the java based application, I am receiving the following error message: (sorry, no Oracle number given).

Attempt to orphan detail rows from <Table_name>. Master rows that have detail rows linked to them cannot be deleted or have their linking columns
modified when cascading deletes and/or updates are disabled. I've looked, but I can't find what would cause this error, nor what can be done to correct it.

Any ideas?

TIA for any help Received on Tue Mar 07 2000 - 00:00:00 CST

Original text of this message

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