Re: Max size of PL/SQL procedure

From: Russ Seligman <rseligma_at_oracle.com>
Date: 15 Jul 1994 17:26:18 GMT
Message-ID: <RSELIGMA.94Jul15102618_at_seinfeld.oracle.com>

In article <304t5d$crg_at_uuneo.neosoft.com> chadb_at_NeoSoft.com writes:

>In <1994Jul14.185033.24646_at_beau.atlanta.dg.com>, klm_at_atlanta.dg.com (Kim Medlin) writes:
>>It appears that we've hit some upper size limit of PL/SQL procedures.
>>We're running Oracle7 and PL/SQL 2.0.
>>
>>What is the upper limit?
>>What work-arounds are available?
>>
>
> The only limits I recall reading about where limits in the client software.
> MS Windows cannot handle more than a 64K block of code. (I'm pretty sure
> it's 64k, but that's kinda fuzzy)

Be aware that the 64K limit applies to the combination of PL/SQL source text *and* the compiled representation of that source. Even 15K of source can exceed the limit once compiled.

--Russ

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-

Russ Seligman                 "If there's nothing wrong with me, maybe
Oracle Graphics                there's something wrong with the universe."
Oracle Corporation               --Beverly Crusher, ST:TNG
rseligma_at_oracle.com            

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Received on Fri Jul 15 1994 - 19:26:18 CEST