Trigger for cascading deletes failing

From: Hello <Hello_at_yahoo.com>
Date: Tue, 07 Mar 2000 10:51:13 -0800
Message-ID: <38C54FA1.75B200C8@yahoo.com>

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 - 12:51:13 CST