RE: output of a select statement(B

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_at_gmail.com] Sent: Wednesday, March 26, 2014 9:27 AM
To: fuzzy.graybeard_at_gmail.com; mwf_at_rsiz.com Cc: oracle-l_at_freelists.org
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

$B:_(B 2014-3-26$B!$>e8a(B12:00$B!$(BHans Forbrich <fuzzy.graybeard_at_gmail.com> $B<LF;!'(B

> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l