Re: ORA-01457

I'm curious to see
1. how datatype of the column is defined in Oracle table (NUMBER? NUMBER (11,2)?)
2. what is the actual maximum data value of that column? are you outputting trace messages to show which row of the table is causing the error?

Nice posting, by the way - lots of pertinent info (sure beats "I'm getting ORA-01457, how do I fix?")

Martin

VictorReinhart wrote:

>I'm getting ORA-01457-converting column overflows decimal datatype
>when doing a FETCH in a MicroFocus COBOL program.
>
>The program was precompiled with Oracle Pro*COBOL 8.1.7 Precompiler,
>then compiled on MicroFocus COBOL 4.1 on Unix AIX 5.1.
>
>It is fetching data from an Oracle 7.3 database on 64-bit DEC Tru64
>Unix.
>
>The fetch variable is PIC S9(9)V99 COMP-3.
>
>The Precompiler and compiler both give a zero return code.
>
>The ORA-01457 happens at runtime, when doing the FETCH. (The CONNECT,
>and OPEN CURSOR work just fine.)
>
>I have tried various workarounds, such as:
>
>1) Use COMP instead of COMP-3. The precompiler complains that the
>variable is too big.
>
>2) Use COMP and reduce variable size from 9 to 7. The precompiler
>complains that scaling is not supported.
>
>3) Remove the V99. It precompiles and compiles, but fails at runtime
>with ORA-01457.
>
>4) Use COMP and remove the V99. It works, however, that removes the
>pennies from my variable, and they are needed.
>
>5) Use COMP-5 instead of COMP-3. The error messages are the same as
>with using COMP-3. (The situation doesn't improve.)
>
>Any suggestions are welcome. There are only two other posts on this
>message, and no resolution was reported.
>
>Thanks in advance :-)
>
>VictorReinhart
>
>
Received on Mon Oct 21 2002 - 13:26:45 CDT