Binay,
Only this database has
cursor_sharing=force
in init<SID>.ora file.
This is a bug, you can check Metalink.
Alex.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 4:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Column Title
Thanks Alex, It worked fine. Still wondering how come that this problem is
only there in one of the 16 Oracle database instance ?
-Binay
----------------------------
Binay,
It is a bug related to cursor_sharing=force.
Try alter session set cursor_sharing=exact.
Alex.
-----Original Message-----
Sent: Wednesday, December 05, 2001 9:25 AM
To: Multiple recipients of list ORACLE-L
Hello DBA-Gurus,
Executing the same query on 2 databases, but getting different output- the
column title. In all the databases its limited to the value of the row
except
in one database we've. All the databases are of 8.1.7.2 running on IBM/unix
server.
Database- A
----------
select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;
SUB
---
LET
Database-B
----------
select substr('LET ME BABY ONE MORE TIME',1,3) FROM dual;
SUBSTR('LETMEBABYONEMORET
--------------------------------
LET
See the output of Database-B - that's the difference from the others.It
seems
that its a database specific problem- we tried with all SQLPLUS versions,
both
Unix and Windows and objerved the same.
Eager to know what makes the difference - all your comments are welcome.
Thanks
-Binay
-------------------------------------------------------------------
The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.
We reserve the right to monitor all e-mail communications through
our network.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
-------------------------------------------------------------------
The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.
We reserve the right to monitor all e-mail communications through
our network.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
