Forum Stats

  • 3,741,441 Users
  • 2,248,430 Discussions
  • 7,861,808 Comments

Discussions

Spool truncating

bobnash251
bobnash251 Member Posts: 56
edited Jun 19, 2014 6:32AM in SQL & PL/SQL


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

Tagged:

Answers

This discussion has been closed.