DBMS_OUTPUT changing spaces to tabs

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Wed, 5 Aug 2009 08:34:07 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E360677A4ED_at_CWYMSX04.Corp.Acxiom.net>

I'm stumped and need some help. I'm running on a Sun SPARC Solaris 10 (5.10) using Oracle My issue is that output from DBMS_OUTPUT.PUT_LINE is different between 2 OS users.  

When I run under my OS account, everything looks fine. But running under "oracle", some spots of the output have multiple spaces replaced with tabs.  

I'm running an anonymous PL/SQL block, which uses DBMS_OUTPUT.PUT_LINE to report on cursor activity. This is all wrapped in a .ksh script, connecting as the same Oracle user each time.  

When connected as "dherri" and running the script, output (saved to a file) looks fine. But when connected to the server as "oracle" and running the script, multiple spaces are replaced with tabs and lines beyond 61 or 62 characters are wrapped instead of extending to 80.  

My guess is there's some difference in an OS setting between the 2 accounts but I sure can't find it. I've looked for any env variable and stty differences and haven't found any. Any clues?  


David C. Herring | DBA, Acxiom Database Services  

630-944-4762 office | 630-430-5988 cell | 630-944-4989 fax

1501 Opus Pl | Downers Grove, IL, 60515 | U.S.A. | www.acxiom.com

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.

Received on Wed Aug 05 2009 - 08:34:07 CDT

Original text of this message