Re: Firing trigger cuts db connection

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 23 Jul 2008 19:32:57 GMT
Message-ID: <JHLhk.1245$%b7.604@edtnps82>


"freecycle" <f.cycle_at_yahoo.com> wrote in message news:3556246e-c0d6-45a3-9099-e60c6b4d1ca7_at_e53g2000hsa.googlegroups.com... 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

Get a tool like PLSQLDeveloper (http://www.allroundautomations.com/) and step through the code with its debugger.

-- 
Terry Dykstra 
Received on Wed Jul 23 2008 - 14:32:57 CDT

Original text of this message