Re: Firing trigger cuts db connection

freecycle <f.cycle_at_yahoo.com> wrote:
> Hi,
> I've created a trigger using the script below.
> whenever I fire it by the statement
> update site_control_t set oid = oid;
> I get
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
> and I'm no longer connected to Oracle.
> Can anyone suggest a reason please, this is driving me crazy!
> Thanks in advance,
> |FC

That's a heck of a trigger.

It would be a lot easier to answer your question if you determined at what line the disconnect occurred. How you can do that depends in part on what version of Oracle you are using (which you should always specify anyway, to get a good answer to your question).

-- 
_______________________________________________________________________
Dan Blum					         tool_at_panix.com	
"I wouldn't have believed it myself if I hadn't just made it up."