Home -> Usenet -> comp.databases.oracle -> What is "Unexpected Oracle Server Termination by Signal 6"?

What is "Unexpected Oracle Server Termination by Signal 6"?

From: <wliu_at_msuvx1.memphis.edu>
Date: 7 Apr 94 20:07:07 -0500
Message-ID: <1994Apr7.200707.16624_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 - 03:07:07 CEST












Original text of this message