Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: raghav_vinjamuri@hotmail.com (Raghav Vinjamuri)
Newsgroups: comp.databases.oracle.server
Subject: PL/SQL:   -- pkg runtime Size Limitations?
Date: 10 Oct 2002 11:32:38 -0700
Organization: http://groups.google.com/
Lines: 40
Message-ID: <2e2fc08e.0210101032.75d082cf@posting.google.com>
NNTP-Posting-Host: 128.107.253.37
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1034274758 11148 127.0.0.1 (10 Oct 2002 18:32:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2002 18:32:38 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163765
X-Received-Date: Thu, 10 Oct 2002 11:32:34 MST (news.easynews.com)

Hi,
   Is there a limit on the max size a PLSQL pkg can
   takeup at runtime on the server?
  
   The issue in essence, is that - we have a 3000 
   line pkg, that works for 299,999 cases out of 
   300,000 cases. 

   But, for that 1 case in 300,000,   the 
   processing breaks down.  

   -  There are no PLSQL exceptions raised.  
   -  We get a ORA-3113 - "end of file on communication
      channel" error in the front end.
   -  Sometimes the db crashes. 

   There is nothing different in terms of data
   volumes or elements being processed.  

   However, given the reproducibility of this error,
   it lead us into thinking that there are some 
   implicit size restrictions on PLSQL packages.

   We have experimented on breaking the package into
   smaller packages, and, per expectations - we do have
   a version that works.  It works SOLID. 

   But, except for this one version that works, 
   there are 4 other versions, similarly "downsized",
   that do NOT work.

   How do we get a clue into breaking this impasse?

   Any pointers/suggestions/comments are gratefully accepted,
Thanks,
Sincerely,
-Raghav Vinjamuri

PS Do let me know if there is a different forum
   where this message should be addressed to. Thanks.