Re: PL/SQL question

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 Fri Aug 18 2000 - 09:20:09 CDT