RE: output of a select statement
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Mar 2014 11:38:39 -0400
Dear Mr. Fishy,
Did you in fact find a login.sql or glogin.sql difference, and did
column "'a'" format a3 hea duh
in your sqlplus session before the query in fact demonstrate that it was a
column formatting problem?
(And I'm not sure I understand your mention of any cursor sharing bugs in
this context, or what was strange about it.)
r,
mwf
-----Original Message-----
From: ORACLE-L [mailto:mr.fishyu@xxxxxxxxx]
Sent: Wednesday, March 26, 2014 9:27 AM
To: fuzzy.graybeard@xxxxxxxxx; mwf@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: output of a select statement
Thank you for your reply,there's another issue within
10.2.0.3,cursor_sharing set to similar or force will trigger the bug.after
setting to exact,this issue fixed too.a bit strange :)
Rgds
David
在 2014-3-26，上午12:00，Hans Forbrich <fuzzy.graybeard@xxxxxxxxx> 写道：
> On 25/03/2014 7:30 AM, ORACLE-L wrote:
>> Hi Group,
>>
>> I have two DBs10.2.0.4 running on Solaris 10.
>>
>> And the output on these two databases are totally different from sqlplus:
> Are these run from the same client? Are they from a client on each
machine or perhaps from a separate client? What happens if you use the same
client to access each DB?
>
> Two things I would check to start
>
> 1) Any login.sql/glogin.sql
> 2) Language/Territory related settings at the client and on the Solaris
machines.
>
> /Hans
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
