DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tab (chr 9) to spaces by ORS

313972Jul 25 2002 — edited Sep 11 2008

Hi
I have a character mode report which generates a one column report - though within that column, I have several fields sep by tab(chr(9)) [sql that feeds to this col is something like select name || chr(9) || code from my_table;]

The output file from the ORS DOESNT contain tabs - it has replaced tab for spaces - to narrow down the problem, I spooled the o/p of the query to a file from a sqlplus window and found that the file had tabs in the correct place.

Why is ORS replacing tabs with space - I suspect I have some property set to wrong value in my .prt file.

My .prt files looks like
---------------------------
printer "dflt"

height 1000
width 1000

linefeed control(J)
---------------------------
I am using ORS version 6.0.8.11.2

Any help/insights would be helpful.
tx, Grv