Skip to Main Content

SQL & PL/SQL

Spool truncating

bobnash251Jun 18 2014 — edited Jun 19 2014


Hi,

I am spooling the output of a function to a file in unix. But i see it is getting truncated after 70 characters.

set serveroutput on size 26000 heading off echo off wrap off termout off feedback off space 0 newpage 0 pagesize 0  verify off

set linesize 45000000 long 42000000 longchunksize 42000000

set trimspool on

column txt format a12000;

Thanks,

Bob

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2014
Added on Jun 18 2014
2 comments
1,394 views