RE: DBMS_OUTPUT changing spaces to tabs

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



Ok, I'm way dumb. The difference is "SET TAB off/on" in sqlplus. My account defines SQLPATH and the login.sql script found there sets it off. The oracle account doesn't set SQLPATH, so it uses the default glogin.sql under $ORACLE_HOME, which leaves SET TAB on. Way simple! Thanks all.

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  

-----Original Message-----
From: Michael Fontana [mailto:michael.fontana_at_enkitec.com] Sent: Wednesday, August 05, 2009 9:38 AM To: Herring Dave - dherri
Cc: oracle-l_at_freelists.org
Subject: Re: DBMS_OUTPUT changing spaces to tabs

Run an "env" unix command and "show all" SQLPLUS command before executing your script in each environment.

Save the outputs into a logfile and compare closely.

There are numerous sqlplus settings that can be set/unset/modified by a great number of things, including login.sql scripts in a specified directory, an env variable that relates to Oracle, or simple output formatting statement in solaris.

Post the results of the above if you still don't see a difference.

  • Original Message ----- From: "Herring Dave - dherri" <Dave.Herring_at_acxiom.com> To: oracle-l_at_freelists.org Sent: Wednesday, August 5, 2009 8:34:07 AM GMT -06:00 US/Canada Central Subject: DBMS_OUTPUT changing spaces to tabs

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.



-- 






Michael Fontana 

Sr. Technical Consultant 

Enkitec M: 214.912.3709 

enkitec

oracle_certified_partner




--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 05 2009 - 10:07:58 CDT

Original text of this message