Re: Update/Select on CHAR Column Behaves Differently In Stored Procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 05 May 2005 19:03:00 +0200
Message-ID: <96kk71dud61gpdui3g0r3dsbb64n7l2mc9@4ax.com>

On 5 May 2005 07:39:27 -0700, "Jesse" <jesjdavis_at_gmail.com> wrote:

>My guess is that the problem lies in the fact that the stubeid variable
>is defined as a VARCHAR2. Am I right on this?

Yes, I think so. Oracle has variable length comparisons (for varchar2 columns) and fixed length comparisons (for char columns) Obviously it chooses fixed length comparisons. I'm not sure why Sql*plus would work, as you don't provide the SQL statement, this is difficult to determine. Probably you have some kind of implicit conversion.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu May 05 2005 - 12:03:00 CDT