Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger for cascading deletes failing
In article <38C54FA1.75B200C8_at_yahoo.com>, Hello <Hello_at_yahoo.com> wrote:
sounds like a "custom" error message they are throwing via raise_application_error() (check their source -- its probably in there). Sounds like, based on the error message, they have a stored procedure or variable you must call/set in a package BEFORE having the delete cascade take effect (eg: you must tell them via a stored procedure call that you want them to cascade a delete -- it does not happen by default).
You really should ask the developers how it works ;)
-- Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries http://osi.oracle.com/~tkyte/index.html -- Opinions are mine and do not necessarily reflect those of Oracle Corp Sent via Deja.com http://www.deja.com/ Before you buy.Received on Tue Mar 07 2000 - 00:00:00 CST
![]() |
![]() |