Re: output of a select statement
From: ORACLE-L <mr.fishyu_at_gmail.com>
Date: Wed, 26 Mar 2014 21:27:18 +0800
Message-Id: <993C2AB1-A8AA-4126-991D-44A7D8650D2C_at_gmail.com>
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 :)
> 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
>
>
Date: Wed, 26 Mar 2014 21:27:18 +0800
Message-Id: <993C2AB1-A8AA-4126-991D-44A7D8650D2C_at_gmail.com>
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_at_gmail.com> дµÀ£º
> 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-lReceived on Wed Mar 26 2014 - 14:27:18 CET