Re: Max size of PL/SQL procedure
From: KIRILLS_at_DELPHI.COM <(KIRILLS_at_DELPHI.COM)>
Date: 15 Jul 1994 01:21:07 -0000
Message-ID: <304oa3$apa_at_news.delphi.com>
Date: 15 Jul 1994 01:21:07 -0000
Message-ID: <304oa3$apa_at_news.delphi.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 biggest stored procedure or package that one can have is 64k. The biggest SQL statement one can issues over SQL*Net is 32K (known bug).
-Kirill SHeynkman Stanford Technology Group, Inc.Received on Fri Jul 15 1994 - 03:21:07 CEST