PL/SQL Command window vs. SQL*Plus - fixed length file

[Tinti]

Hello

I try to write a file in a fixed length structure using pl/sql command window. Following the script:

clear
SET LINESIZE 384
SET COLWIDTH 0
SET PAGESIZE 0
SET FEEDBACK OFF
SET TERMOUT OFF
SET TRIMSPOOL OFF
SET TRIMOUT OFF
SET ECHO OFF
SET SQLBLANKLINES ON

SPOOL  C:\TEMP\MyFile.csv

SELECT    rpad(nvl(object_typ ,  ' '), 2)
       || rpad(nvl(object_rolle, ' '), 2)
       || rpad(nvl(object_id,    ' '), 40)
       || rpad(nvl(feature_id,   ' '), 40)
       || rpad(nvl(value,        ' '), 50)
       || rpad(nvl(remark,       ' '), 250)

FROM mytable

;
SPOOL OFF

Unfortunately trailing blanks will be skipped. The linesize parameter seems to be ignored.

If I run the same script in SQL*PLUS the trailing blanks are included.

How can I handle this in PL/SQL command window?

Thanks a lot for every hint.

 

[Marco Kalter]

I'm afraid this is not possible. Trailing spaces are indeed removed during spooling.

 

[Tinti]

Hi Marco

thx for the very fast response.

Have a nice day