Re: Problem in Pro*C

It looks like you are hitting a BUG which we got in Oracle7.3.?, where by Oracle would store the value incorrectly inside the Oracle database AND inside the Oracle Redo Log files. It only effects 10 digit numbers as well.

Ask Oracle for the Bug investigation. Sorry can't remember the actual BUG# but we did get a patch.

Andrew

Anil K Neela wrote:

> Hello,
>
> I am trying to run a little program, where in i try to insert values into
> a table through pro *c.
> The structure of the table is something like this..
>
> Name Null? Type
> ------------------------------- -------- ----
> CARRIER_ID NOT NULL NUMBER(2)
> GSAS NOT NULL CHAR(19)-------
> FAMILY_DEDUCT NOT NULL NUMBER(6,2)
> FAMILY_IND_DEDUCT NOT NULL NUMBER(6,2)
> ANNUAL_MAX NOT NULL NUMBER(8,2)
> LIFETIME_MAX NOT NULL NUMBER(10,2) ------
> COB_FLAG NOT NULL CHAR(1)
> LOOKUP_RULES NOT NULL NUMBER(1)
>
> It contains a field LIFETIME_MAX number (10,2)
>
> In pro *c, i declared the SQL variables TEMP_LIFETIME_MAX as a double,
> I am reading the values to be inserted from a file, and for diff recors
> TEMP_LIFETIME_MAX has values like
> 100000001/100
> 100000000/100
> 100999999/100
> and then that value is stored in LIFETIME_MAX field in the table.
> But when i do a select, the output is like this.
>
> It is displaying 100000000/100 as :00000, instead of 1000000
> GSAS LIFETIME_MAX
> ------------------- ------------
> 090536 01 000001 1009999.9
> 090536 01 000002 1000000.01
> 090536 01 000003 :00000
>
> Can you tell me why this is happening..
>
> Anil
>
> *******************************************************************************
> Anil K Neela
> Ph: (618) 650 4026
> E-mail: aneela_at_siue.edu
> URL: http://www.siue.edu/~aneela
> *******************************************************************************
Received on Wed Apr 21 1999 - 18:50:58 CDT