Okay,
I have independent verification, so I am NOT delusional...
I
reconnected to the 9.0.1 database, reran the query and the lines were not
truncated!
I'm
STUMPED!
-----Original Message-----
From: Fink, Dan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 12, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
Subject: SQL*Plus truncating linesI'm calling each statement from SQL*Plus for Windows 9.2.0.1.0. When I connect to a 9.0.1 database and execute a query, the output to the screen is truncated at 100 characters. If the output is spooled to a file, all lines appear as expected. When the same session is connected to an 8.1.7 database, the output is not truncated. When the same statement is run on the box using the unix command line version, it is not truncated.linesize - 150command_string (column of output) a145echo off pages 0Any clues as to why the database connection matters? Is it actually something with SQL*Net? Any other things to check?Dan Fink