Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question on implicit number to string conversion

Re: Question on implicit number to string conversion

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 05 Dec 2002 17:04:58 +0100
Message-ID: <h7uuuu4b4fu4l2nvmt4nfbobv2fl3bf34d@4ax.com> 





On Thu, 05 Dec 2002 12:05:02 +0100, Eberhard Binder
<Eberhard.Binder_at_LHSystems.com> wrote:



>Any hints what causes this behaviour?





Overflow. You are fetching a number column in a string column without
explicit conversion and the implicit conversion results in a string
which is longer than your string host variable allows.



Hth




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Thu Dec 05 2002 - 10:04:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US