Re: trouble with ORA-04094

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 1 Apr 2002 12:38:07 +0200
Message-ID: <uagell5gl5id23@corp.supernews.com>

"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?

Upgrade to a supported version

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Apr 01 2002 - 04:38:07 CST