Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news-out.visi.com!petbe.visi.com!tor-nx1.netcom.ca!tor-nn1.netcom.ca.POSTED!not-for-mail From: "Syltrem" Newsgroups: comp.databases.oracle.server References: Subject: Re: trailing spaces Lines: 33 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: Date: Fri, 12 Dec 2003 12:02:34 -0500 NNTP-Posting-Host: 216.191.6.50 X-Complaints-To: abuse@allstream.net X-Trace: tor-nn1.netcom.ca 1071248326 216.191.6.50 (Fri, 12 Dec 2003 11:58:46 EDT) NNTP-Posting-Date: Fri, 12 Dec 2003 11:58:46 EDT Organization: Allstream Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:249993 show parameter cursor_sharing when FORCE Oracle will treat your immediate values (like '1') as a bind variable for which it cannot determine the length. One workaround is to ALTER SESSION SET CURSOR_SHARING=EXACT for the session having the problem. It may or may not be a solution though, you`ll have to determine this yourself. HTH -- Syltrem OpenVMS 7.3-1 + Oracle 8.1.7.4 http://pages.infinit.net/syltrem (OpenVMS related web site, en français) ---zulu is not in my email address--- "Ravi Tallury" a écrit dans le message de news:da422b76.0312120829.5db98e29@posting.google.com... > Hi > When i do a > select '1' from dual from one instance of the database, i get only a > single chanrecter. > > However when i run the same query from an other instance, i get a > blank padded string. This has been causing problems in our application > because of logic we use, any help in figuring out the reason and the > remedy would be quite helpful. > > Thanks > Ravi