Home » Developer & Programmer » Precompilers, OCI & OCCI » fetching into a double from pro*c program
fetching into a double from pro*c program [message #94069] Tue, 23 December 2003 00:10 Go to next message
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
Member
Hi,
I want to fetch data from number column (value is 100400000664137.68) into double host variable in a pro*c program. When i fetch and print, the value is getting rounded as 100400000664138.000000. I dont want this rounding off to happen as i have some calculations based on this value. Pls suggest me how can i avoid this rounding off problem?
I tested this on oracle 9.2.0.4.0 (proc release 9.2.0.4.0) and oracle 8.0.5.0.0
versions (pro*c version 8.0.5.0.0).

Thanks in advance.
Giridhar
Re: fetching into a double from pro*c program [message #94077 is a reply to message #94069] Mon, 05 January 2004 02:31 Go to previous message
Lakshmi Narayana P
Messages: 2
Registered: January 2004
Junior Member
Id depends upon the host variables you declared to fetch such a huge content.
I suggest declare host variable as long double then try for the accuracy

Thanks & Regards
Lakshmi Narayana P
Previous Topic: Pro*C compile problem
Next Topic: Pro C likes DECLARE, OPEN cursor, but not FETCH?
Goto Forum:
  


Current Time: Mon Mar 04 22:30:12 CST 2024