Help again

[gieboy]

set heading off
set headsep off
This is my sample script:

set pagesize 3000
set linesize 80
set feedback off

connect pro/prospero3@pro3;

spool c:\test.lis

select substr(upd.area_code.AREACODE,1,11),to_char(substr(upd.destination.CARRIER,1,4),'0000') de from upd.area_code,upd.destination where upd.area_code.destination = upd.destination.DESTINATION;

spool off



output is something like this


0755571 0001
0755573 0001
0755550 0001
0755056 0001
0755057 0001
0755058 0001
0755781 0001
0755782 0001
0755783 0001
075575 0001
075518 0001
0777285 0001
07772251 0001
Input truncated to 9 characters


How can i get rid of the message "Input truncated to 9 characters"

 

[sem]

Just add new line to the end of your script.

 

[rtefft]

This is a common SQL*Plus problem. It's harmless, but to get rid of it, add a return to you last line, so the file ends with a blank line. SQL*Plus expected a CR and found the end of the file instead.

Rich Tefft ____________________________
Rich Tefft
PL/SQL Programmer