Re: ORA-3113 and 1041 with large PL/SQL scripts

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: Sat, 25 Apr 1998 16:13:37 GMT
Message-ID: <35474594.9590565@read.news.global.net.uk>

On Tue, 21 Apr 1998 16:14:40 -0500, "Bart Kersteter" <bjkerst_at_mcc-care.com> wrote:

>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).
>

I had this problem once. I can't remember the cause, but it was the result of a particular section of the code, which i identified by commenting out procedures in a sort of binary search until I found the statements in error. Received on Sat Apr 25 1998 - 11:13:37 CDT