Home » Developer & Programmer » Precompilers, OCI & OCCI » Pro C Data Type ISSUE !!!!!!!  () 1 Vote
Pro C Data Type ISSUE !!!!!!! [message #193987] Wed, 20 September 2006 05:32
nemesisneo
Messages: 1
Registered: September 2006
Junior Member
-

When using the Dynamic SQL Method 4:

From database Side , REQUIRED Column ABC is defined as NUMEBR(38).

It stores value: 3003486271 (which is greater than C INT_MAX limit)

When the value was read in host variable of type INT, it created an issue. (Overflow error)

Can it be read into a Double host variable , will putting in NUMBER(38) in double create any issue.

Coz: When in C program, if one puts:

double j;
j = 3003486271;
printf(this number) -> will created a problem coz Interger to double conversion will overflow

but if we do:

j = 3003486271.0;
printf(this number) -> it works fine as it knows the number is double (explicitly done)

Any theory on how dynamic method 4 works and how NUMBER Internal datatype moves to various C data types .... Any help on problem above would be useful , Thanks in anticipation

Previous Topic: help!!!it's not the desired result of oci bulk update!!
Next Topic: segmentation fault from vector
Goto Forum:
  


Current Time: Thu Mar 28 16:05:16 CDT 2024