Xref: alice comp.databases.oracle.misc:15046
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-ge.switch.ch!news-zh.switch.ch!sibyl.sunrise.ch!svnews.ubinet.ubs.com!svusenet.ubs.ch!usenet
From: Eugen Nyffeler <eugen.nyffeler@ubs.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: package limitations
Date: Tue, 05 May 1998 18:43:39 +0200
Organization: Union Bank of Switzerland 
Lines: 23
Message-ID: <354F41BB.204A4D81@ubs.com>
References: <6ilssl$oif$1@news.tdl.com>
Reply-To: eugen.nyffeler@ubs.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Chris Taylor wrote:
> 
> Is there a limit on the size of a Package.... Out dba swears
> there is even though I cannot find a single reference in the
> documentation.

Hi Chris

I had once the problem that the software (16bit-version) on the PC
was not able to process files larger then 32K (i'm not shure
if it was the sql*net or not).
On the unix box there was no problem (size was around 40k), but
packages so large are a pain in the a... to support.
I can only think of two possible limitations.
- the definition for the linenumber in the dba_source is number
   and the textlength per line is 2000 chars.
   So number of lines  * line length = max --> 
   should be somthing like 10e37*2000=2e40 ??
- the person which must support the code


HtH
eugen