DBMS_OUTPUT changing spaces to tabs
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 10.2.0.3. 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?
Thanks.
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 05 2009 - 08:34:07 CDT