Hi All

I have set cursor_sharing = FORCE , Now when I give a query say select
'abc' from dual; It is getting padded to the right with some spaces which I
am not able to remove with a trim also. The same query when run againt a
database with Cursor_sharing = exact will reurn without padding. So the
application running against the first database is returning values padded
with junk char causing it to fail. Any remedy for this other than setting
cursor_sharing to exact

Best regards
Deepu


DISCLAIMER: Information contained and transmitted by this E-MAIL is
proprietary to Mascot Systems Limited and is intended for use only by the
individual or entity to which it is addressed, and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law. If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible for
delivering the information to the named recipient, you are notified that any
use, distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail & notify us
immediately at [Email Address Removed] Before opening attachments,
please scan for viruses.


Oracle LazyDBA home page