Re: How to use VARNUMS in OCI???

In article <4e3nrm$e1l_at_news1.svc>, sjs_at_shell.portal.com (Steve Schow) writes:
|> I have an OCI question for you.
|>
|> We are trying to deal with 64 bit ints...which in C are refferred to
|> as
|>
|> long long
|>
|> datatypes.
|>
|> It seems that in order to deal with these datatypes in OCI, we will
|> have to write some kind of routine that converts a long long to
|> an oracle varnum and back again.
|>
|> Do you know what the easiest way to do this would be or do you have
|> any suggestions at all?

That's certainly one possibility. However, why convert into a varnum? Convert it into a character string instead. This can be as many digits as you like (plus C can do this already). Oracle will automaticly convert between character strings and NUMBERs. Plus, since both NUMBERs and strings are in a decimal format, you won't loose any precision.

|>
|> Thanks in advance
|>
|> --
|> ------------------------------------------------------------------
|> Steve Schow | But you don't need to use the claw, if you
|> sjs_at_corp.portal.com | pick the pear of the big paw paw......
|> (408) 973-9111 x110 | Have I given you a clue......?
|> (408) 265-4551 (hm) | - Baloo the Bear
|> ------------------------------------------------------------------
|> HomePage: http://www.bstage.com/
|> HomeAddr: sjs_at_midiman.bstage.com
|> ------------------------------------------------------------------
|>
|>
Received on Fri Jan 26 1996 - 00:00:00 CET