?? Server Terminaated By Signal 6?? on Unix, PL/SQL

From: <wliu_at_msuvx1.memphis.edu>
Date: 7 Apr 94 21:28:01 -0500
Message-ID: <1994Apr7.212801.16628_at_msuvx1.memst.edu>


Hi, experts,

I need some your help to solve my problem. Problem:

 I wrote a 900+ lines PL/SQL script with 150 variable declared.  Everything is OK until I add a cursor at the end of the script,  which is a single table select statement just return one record  but has 45 columns in it.

 The Fetch of cursor was fine. But when I used the variables which  are fetched into, the PL/SQl script crashed with no ORACLE Error. Only  give a Error Message: "Unexpected oracle server termination by signal 6".

 When I use any three or four of the 45 varriables, the script  runs fine. But when I use any six or seven of them, the script  crashed. So, I am confident this is not a coding problem.

System:

 Oracle V6.0.33 on Sun OS 4.0; 16 M main memory + 32 M Swap.  Oracle SGA about 700K, Context Size as default(4K I believe).  When testing, I the only user on the system.  

Any suggestion? Thanks a lot.

Bill. Received on Fri Apr 08 1994 - 04:28:01 CEST

Original text of this message