Re: Firing trigger cuts db connection

On Jul 23, 6:04 pm, t..._at_panix.com (Dan Blum) wrote:
> freecycle <f.cy..._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                                                 t..._at_panix.com        
> "I wouldn't have believed it myself if I hadn't just made it up."

Dan,
this is Oracle 8i on Windows.
How can I determine when oracle disconnects? |FC Received on Wed Jul 23 2008 - 14:17:40 CDT