Re: PL/SQL question

Hello,

    Download a free 30 day copy of EZSQL _at_ http://www.ezsql.net.

    It is a better tool than toad (my own opinion) and will help you de-bug your code.

    I have some packages 10-20 times the size you describe, so size is not the issue.

    Good Luck,

john

"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> _at_Package.sql
> > Package Created.
> > SQL>_at_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 Sun Sep 03 2000 - 13:06:25 CEST