Re: Return from function forces CR/LF ???

On Fri, 28 Feb 2003 09:50:08 -0800, "Bill Rowland" <billrow_at_onemain.com> wrote:

>Any ideas how I can suppress the CR/LF in the output???

There is no CR/LF in the output. Your linesize parameter is insufficient forcing sql*plus to wrap.

You can resolve this by either
- put a
  column <column_name> format a<n>
  before the select, to reduce the width of the column - or
  use
  set linesize 132
  before the select

like this

SET COLSEP '|';
column order_flag format a32
set linesize 132
select product_number, part_number,

           (spi.is_orderable(part_number)) as order_flag from structure;

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 28 2003 - 12:47:55 CST