Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xit-03!sn-xit-09!sn-xit-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Update/Select on CHAR Column Behaves Differently In Stored Procedure Date: Thu, 05 May 2005 20:07:00 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: sybrandb@hccnet.verwijderdit.nl References: <1115303967.585241.275350@f14g2000cwb.googlegroups.com> <96kk71dud61gpdui3g0r3dsbb64n7l2mc9@4ax.com> <1115314726.991159.214430@f14g2000cwb.googlegroups.com> X-Newsreader: Forte Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 30 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:242090 On 5 May 2005 10:38:47 -0700, "Jesse" wrote: >Sorry, the SQL statement was simply the same core statement, only no >variable: > >UPDATE zkora.ttr_utstandardsrun > SET dimdatauploaded = 1 > WHERE utstandardfilename_text = 'A0000J6W' I was afraid to see a statement with a hard-coded literal, and here it is. Could you do the following variable param varchar2(8) begin :param := 'A0000J6W'; UPDATE zkora.ttr_utstandardsrun SET dimdatauploaded = 1 WHERE utstandardfilename_text =:param; end; / and verify it fails? You are comparing apples and pears really. Hard-coded literals are automatically padded with spaces, when necessary, in any programming language. -- Sybrand Bakker, Senior Oracle DBA