OraFAQ Forum: Precompilers, OCI & OCCI » fetching into a double from pro*c program

Home » Developer & Programmer » Precompilers, OCI & OCCI » fetching into a double from pro*c program

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

fetching into a double from pro*c program [message #94069]

Tue, 23 December 2003 00:10

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

Report message to a moderator

Re: fetching into a double from pro*c program [message #94077 is a reply to message #94069]

Mon, 05 January 2004 02:31

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

Report message to a moderator

Previous Topic:	Pro*C compile problem
Next Topic:	Pro C likes DECLARE, OPEN cursor, but not FETCH?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 21:57:35 CST 2025