Re: 8i SQL Plus Edit Question

Frank van Bortel wrote:
> Tim Marshall wrote:
> > fitzjarrell_at_cox.net wrote:
> >
> >> Tim Marshall wrote:
> >>
> >>> Server 8.1.7.4.0, SQL Plus 8.1.7.0.0 I'm trying to see if SQL PLus can
> >
> >
> >> All of these run in SQL*Plus; your file, per se, wasn't truncted, just
> >> the lines exeeding 255 characters (I believe that is the line length
> >> limit).
> >
> >
> > Perhaps that was the cause. What appeared to be happening, though, was
> > as soon as a line was truncated, none of the following lines were
> > allowed. Does that sound right?
> >
> > In my apps, I construct SQL strings from VBA. I will pay attention to
> > the character length of lines the next time - it sounds like that will
> > probably take care of things.
> >
> > Thanks David, I appreciate the response.
> >
> One (or two) additional comments:
> - it is not clear whether you use the GUI or the command line
> version of SQL*Plus (that would be sqlplusw.exe versus sqlplus.exe)
> The command line version allows for more size than the GUI.
> - svrmgrl allows for even larger commands than sqlplus; David may have
> mixed commands with file sizes - a single command is executed with '/',
> or finishes with ';'.
>

Please look at the filenames again, as these are all wrapped package bodies supplied by Oracle, and none have a / until the very end. However, your point is taken.

> There is a 32kB barrier in your version of plus; 64 for the commandline
> if I remember correctly (and failing to retrieve the size for svrmgrl)
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

David Fitzjarrell Received on Wed Sep 28 2005 - 15:29:11 CDT