Re: Writing to a text file from PL/SQL

Tim Cross <tcross_at_nospam.une.edu.au> writes:

> Álvaro Palma Aste <queria_direccion_at_el.perla.invalid> writes:
> From memory, I think DBMS_OUTPUT may also trim leading/trailing white
> space - so any formatting may get modified/lost - not sure about this
> though, I just recall something I encountered where the output was
> modified by DBMS_OUTPUT.

In SQL*Plus, SET SERVEROUTPUT syntax has an option FOR[MAT] {WRA[PPED]|WOR[D_WRAPPED]|TRU[NCATED]} to control formatting. See http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a90842/ch13.htm#1012919

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.