Home » SQL & PL/SQL » Client Tools » Input truncated coming in the sal generate report (oracle 8 i)
Input truncated coming in the sal generate report [message #313509] Sun, 13 April 2008 04:39 Go to next message
melvinRav
Messages: 43
Registered: April 2008
Location: India
Member
I am facing a problem , i am generating report in csv format , but but the report always contains in the n + th line
the following, statement
Input truncated to 10 characters

I have no idea how thats coming ,

please help out if there is a way to avoid getting the input truncated
i use the following code at the starting
to create a new report

SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 123
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF

Re: Input truncated coming in the sal generate report [message #313512 is a reply to message #313509] Sun, 13 April 2008 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Add a new line at the end of the script.

Regards
Michel
Re: Input truncated coming in the sal generate report [message #324553 is a reply to message #313509] Tue, 03 June 2008 02:13 Go to previous message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
OR you end every statement with ";" like

SET FEEDBACK OFF;
.
.
SET HEADING OFF;

Regards,

MSMallya

[Updated on: Tue, 03 June 2008 02:16]

Report message to a moderator

Previous Topic: how to not display substitutions in a spool file
Next Topic: Oracle7 RDB JDBC Connection String in SQLDeveloper
Goto Forum:
  


Current Time: Thu Dec 08 22:18:28 CST 2016

Total time taken to generate the page: 0.07217 seconds