Re: CREATE PACKAGE problem
From: Alvin W. Law <alaw_at_oracle.com>
Date: Mon, 11 Apr 1994 08:45:17 GMT
Message-ID: <ALAW.94Apr11004517_at_ap221sun.oracle.com>
Date: Mon, 11 Apr 1994 08:45:17 GMT
Message-ID: <ALAW.94Apr11004517_at_ap221sun.oracle.com>
In article <1994Apr10.143147.14863_at_ericsson.se> ebcrbj_at_ebcw150.ericsson.se (BO/EBC/KX/RGFC Roger Bjaerevall 08-682 4851) writes:
>
> Does anyone know the solution to this undocumented error message:
>
> "ORA-04046: results of compilation are too large to support".
>
> It is the result of a 'CREATE OR REPLACE PACKAGE BODY' operation
> in SQL*Plus.
I haven't seen this Oracle error before but it seems obvious that your package is way too large to be practical. Remember the whole compiled package body will be brought into the SGA once called, so you might want to break out your package into smaller pieces.
-- Alvin W. Law .............................................. Oracle Corporation Project Leader, Cost Management .................. 300 Oracle Parkway, Floor 6 Manufacturing Applications .......................... Redwood Shores, CA 94065 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299 ORA-03113: end-of-file on communication channelReceived on Mon Apr 11 1994 - 10:45:17 CEST