Re: trailing spaces

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Fri, 12 Dec 2003 12:02:34 -0500
Message-ID: <atmCb.6956$G1.32132@tor-nn1.netcom.ca>

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" <talluryr_at_yahoo.com> a écrit dans le message de
news:da422b76.0312120829.5db98e29_at_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

Received on Fri Dec 12 2003 - 11:02:34 CST