proc*c problem; select statement malfuction

Hi,

I get a problem with select statement in pro*c. I need to select a NUMBER(38) type value in database into long varialbe in the pro*c code. But when I run this code, always a wrong value got selected into that variable. The same select statement works Ok in sqlplus; it also works OK if I copy this piece of code and put it into a small driver program. The select statement is used at more than 100 places in my program, but the error only happens at one place, and that place has nothing special.

I wonder what might cause this problem; it is really weird.

Please email me to juncao_at_hotmail.com. Thanks!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 01 1999 - 16:46:06 CST