Re: trouble with ORA-04094

From: Sergey M <msu_at_pronto.msk.ru>
Date: Mon, 1 Apr 2002 14:17:40 -0800
Message-ID: <a89c5f$2skt$1@serv2.vsi.ru>

Pls, post test of yours trigger.

Sergey M.

"Gunjan" <gunjansahay_at_yahoo.com> wrote in message news:15921bee.0204010213.6651769b_at_posting.google.com...
> hi
> i have Oracle 8i verion 8.1.5 on my machine and i have table and a
> trigger created on it. the trigger does nothing but a cascaded delete
> from the child tables. ita row level trigger.
> however, on a ORacle8.0.5 the same trigger throws up this ORA-04094
> error when i delete frm the parent table; whereas the same works
> perfectly fine on Oracle8.1.5..now i cant drop and recreate the 8.0.5
> table/trigger but i do need to get rid of this problem finding a work
> around..can someone PLEASE sugggest me something?
Received on Mon Apr 01 2002 - 16:17:40 CST