Re: PL/SQL question

There seems to be some kind of limit for package size. I run into to this limit when my package file exceeded the length of 4600 lines. My version of SQLplus did not crash (I don't know the version number), it just gave an error message "program too large". I had to split that package to two different packages to continue.

Lisa Adcock <ladcock_at_ford.com> wrote in message news:8njgbh$o269_at_eccws12.dearborn.ford.com...
> That is what I have. I have a "pkgBody.sql" which is about 800 lines.
> I backtracked and removed all my procedures and started adding them back
 in
> one at a time. Everything was fine until the last procedure (let's call
 it
> "A") was added. Then it crashed. So, I said, "Well maybe it's something
> with procedure "A"".
>
> So I took another procedure "B" out and reran the script. The package
 body
> was created with compilation errors(because I was missing a procedure "B")
> so that was good. But when I put the procedure "B" back in, SQL*PLUS
> crashed. All I can think, is it's some sort of size limit.
>
> My only other clue at this point is to create TWO packages. Since this is
> my first large PL/SQL program, I am running into road blocks on how to
 debug
> this thing. Any help is greatly appreciated.
>
> "Mark G" <markag_at_wonderstats.com> wrote in message
>

 news:F4155D9F9AA4D111B9990020AFBA52D53F6978_at_class06.ip061.sfi-software.com..
> .
> > Yes there is, but that seems too small to be a package size issue.
> >
> > Try putting the package and package body creation code into a script and
> > fire the script from SQL*Plus:
> >
> > SQL> @Package.sql
> > Package Created.
> > SQL>@PackagBody.sql
> > Package Body Created.
> > SQL>
> >
> > or something like that.
> >
> > "Lisa Adcock" <ladcock_at_ford.com> wrote in message
> > news:8nj9fg$o2b4_at_eccws12.dearborn.ford.com...
> > > Is there a maximum size that a package can be?
> > >
> > > My package body is about 800 lines and SQL*Plus is crashing. I am
 using
> > > SQL*Plus 3.1.3.5.4(yes, I know it's old).
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Mon Aug 21 2000 - 03:49:45 CDT