Re: SQL statement breaking the connection with ORA 3113

Hi,
It is not 100% sure, I think that check your machine parameters limit command
if cputime limit is setting any short number, then oracle will be down during some sessions

• nolja96 --

George Zachary wrote:

> Hi,
>
> I did up upgrade 7.3.2 --> 7.3.4 ---> 8.0.5 on UnixWare 7.1. Which is
> not certified.
> However, I have this ProC program which does not work anymore, at one
> stage is doing
> an "update ...set X = NULL ..." and it can not perform it. It actually
> breaks the connection
> and returns ORA-03113. I have tried manually, I inserted a new row and
> left column X (it's VARCHAR2(2))
> null, I can update any column but this one, regardless of the value.
> Tried NULL, ' ', 'Z', but no luck.
> My sqlplus session gets disconnected after a while.
> Any idea ?
>
> Thanks,
> George
Received on Wed Jun 16 1999 - 17:20:29 CEST