Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-3113 and 1041 with large PL/SQL scripts
Hi, Bart.
I just got the same error myself. After a LONG time with Oracle tech support I learned :
Good luck. Michael.
In article <6hhdlu$jut$1_at_supernews.com>,
"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).
>
> Might one of the PL/SQL gurus out there have any ideas to try?
>
> Thanks,
>
> Bart
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat Apr 25 1998 - 15:00:22 CDT