?? Server Terminaated By Signal 6?? on Unix, PL/SQL
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