Re: Sql Plus configuration question

Micheal ,

The linesize is at most 255 bytes in sql*plus. The set linesize command will not give you an error if you go over 255 but it will when you display a line over 255 bytes;
for example

      set serveroutput on size 1000000 ;
      dbms_output.put_line (rpad ('A',256,'A')) ;

Now you could set the buffer size up to 1000000 by using the procedure : dbms_output.enable (1000000) ;

Michael Will de Laforcade wrote in message <6fb9ib$8j9$1_at_news0-alterdial.uu.net>...
>I am seeting up the "login.sql" file for SqlPlus. I am having problems with
>the following and would appreciate help:
>
>this works..........set linesize 1000
>
>but in the program I also need to set the buffer width to get very wide
>lines.
>The problem is there doesn't seem to be a "set bufferwidth" command.
>
>How do I force the buffer width to also be 1000??
>
>
>Thank Michael.
>
>
Received on Wed Mar 25 1998 - 00:00:00 CET