Re: [Q]: Developer/2000 PL/SQL editor limits package size???

The limit is 64k. It is not the forms editor, but the database itself. If you were to use Procedure Builder you would see the same occurance.

If you goto http://www.oracle.com/support and log into metalink you can query a GSX Entry that has all of the limits for forms (and DB) objects.

Mark

On Mon, 28 Sep 1998 17:02:34 +0100, Martin Vorbeck <vorbeck_at_val.indra.es> wrote:

>Hi,
>
> using Developer/2000's PL/SQL editor to edit database packages, I
>ran into the following limitation.
>When my package body grows very large, there comes a point where
>characters typed are not inserted any more.
>Deleting some characters (e.g. comments) allows me to insert as many
>characters as I have deleted. It happens for example
>with a package body reaching 59379 bytes total size.
>
> Using SQL Worksheet, on the other hand, I am able to increase the
>size of the package body without problems, using
>CREATE OR REPLACE PACKAGE BODY AS ....
>
> So, if I understand well, it seems that Developer/2000 (Version 1.5)
>limits the size because of some restriction with the
>PL/SQL editor. Now my question: is this so? Does anyone know a trick to
>work around this limitation?
>
> Of course I could always use a SQL script with CREATE OR REPLACE as
>I go along editing my package, thus editing directly the script, but
>this gets quite tedious, especially as far as compilation error
>detection goes. I haven't found a more convenient way to directly
>display compilation errors, other than through Developer/2000's PL/SQL
>editor...
>
> Thanks for any help or insights on this issue,
>
> Cheers,
>
> -- Martin Vorbeck
> Valencia, Spain
Received on Fri Oct 02 1998 - 03:52:51 CEST