ORA-3113 and 1041 with large PL/SQL scripts

From: Bart Kersteter <bjkerst_at_mcc-care.com>
Date: Tue, 21 Apr 1998 16:14:40 -0500
Message-ID: <6hhdlu$jut$1@supernews.com>

Hello,

I'm writing a decent-sized PL/SQL package (2000 + lines ) and when I try to compile the package body, I get an ORA-3113 'End of file on communication channel.' This is followed up with an ORA 3114 immediately. When I exit SQL*Plus, I get an ORA-01041 'hostdef extension doesn't exist' error.

I've checked with Oracle Metalink and they suggest taking out any DBMS_OUTPUT procedure calls. This doesn't work for me, unfortunately. Also, I've increased my buffer size, MAXDATA and serveroutput buffer size to the max. (This is on a server with 1GB RAM and an SGA sized to match).

Might one of the PL/SQL gurus out there have any ideas to try?

Thanks,

Bart Received on Tue Apr 21 1998 - 16:14:40 CDT