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: Eberhard Binder <Eberhard.Binder_at_LHSystems.com>
Date: Thu, 12 Dec 2002 09:18:22 +0100
Message-ID: <3DF8464E.9040404@LHSystems.com>


Sybrand Bakker wrote:
> 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.
>

Hallo,
  it looks like, that the overflow is not a working description for our problem. We changed the definition of the string value inside the SAP ABAP-code to a larger value, and observed the same behaviour.

  Now, we have decided to change the code. We will perform an explicit conversion with TO_CHAR(numer_value) inside the SELECT-Statement.

Thanks for the answer.

Gruß, Eberhard Received on Thu Dec 12 2002 - 02:18:22 CST

Original text of this message

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