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 :)

Rgds

David

2014-3-2612:00Hans 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-l
Received on Wed Mar 26 2014 - 14:27:18 CET

Original text of this message