Re: stored package size limitation?
From: AngeloJS <angelojs_at_aol.com>
Date: 1996/07/09
Message-ID: <4ruqc5$2n5_at_newsbf02.news.aol.com>#1/1
Date: 1996/07/09
Message-ID: <4ruqc5$2n5_at_newsbf02.news.aol.com>#1/1
Yes,
I am using Oracle 7.1.4 as well, and am an AVID believer in Packages. There used to be a 64K limit in Oracle 7.0.16, but Oracle claims that that was increased to 100K in Oracle 7.1+. I have hit my head on the ceiling with a compiled code size of 78K (sys.dba_object_size). Fortunately, it has been easy enough for me to break this down by "subclassing" the package.
When I think about it, maybe 64K is enough if you design the packages discreetly enough.
Hope this helps,
J. Scott Angelo Received on Tue Jul 09 1996 - 00:00:00 CEST