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: 31
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 message
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Add a new line at the end of the script.

Regards
Michel
Previous Topic:SP2-0310
Next Topic:TOAD i don't know how to load .dat file
Goto Forum:
  


Current Time: Sat May 17 03:54:56 CDT 2008

Total time taken to generate the page: 0.06898 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.