| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL generating SQL - stupid question continued lines
Paula,
There are several things to look at. 1) Make sure the size of the output 'column' is large enough to enable breaks to occur properly. 2) When setting linesize, add in any columns that are NOPRINT. Make it large enough that it has plenty of buffer spaces. 3) SET RECSEP OFF. The default is WRAPPED which adds in an additional line if a record is 'wrapped'.
Daniel Fink
Paula_Stankus_at_doh.state.fl.us wrote:
>Guys,
>
>I hope you don't mind answering this - I am sure I answered this at one =
>time but now forgot the answer.
>
>I have some SQL generating SQL but there are skipped lines so the =
>commands do not look correct and I get=20
>
>SP2-....unknown command.
>
>What is the set command to change this behavior?
>
>Thanks,
>Paula
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Aug 19 2004 - 12:03:22 CDT
 |
 |