Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-3113 and 1041 with large PL/SQL scripts

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

From: <bialik_at_wis.weizmann.ac.il>
Date: Sat, 25 Apr 1998 14:00:22 -0600
Message-ID: <6htbs7$mpk$1@nnrp1.dejanews.com>


Hi, Bart.

 I just got the same error myself. After a LONG time with Oracle tech  support I learned :

  1. Never write packages over 64K size.
  2. ERR3113 is caused by Oracle bug, but it may by by-passed by changing an application a bit. In my case it was caused by definition of PL/SQL table of RECORDS and using assignment T_FIELD := TO_NUMBER (PLSQTAB(i).FIELD_NAME); Apparently PL/SQL functions don't deal to well with that case. To by-pass the problem we used : T_FIELD_CHAR := PLSQTAB(i).FIELD_NAME; T_FILED := TO_NUBER(T_FIELD_CHAR); It solved the problem here.

 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US