Home » Other » 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

Report message to a moderator

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: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Add a new line at the end of the script.

Regards
Michel

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 03 06:36:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.