int64, DOA, and Oracle 7.3.4

[Tom]

I'm looking for information on what the "best practice" is when working with Delphi 5's int64 type, DOA, and Oracle Server 7.3.4 (we will be moving to 8 but not quite yet).

The best I have come up with so far is to pass the int64 value back and forth from/to my queries as a string and perform the conversion in my query, pl/sql block, stored procedure, etc.

Has anyone else here had to deal with such large integer values?

Thanks in advance for any enlightenment, suggestions, etc.

------------------
Tom Clowers

 

[Marco Kalter]

Large integers will be treated as Doubles by default (the otFloat variable type). This provides more precision than a standard integer. Beyond the precision of a Double (15 digits) you have to use strings. The TOracleSession.Preferences.IntegerPrecision and FloatPrecision may be helpful in that case.

------------------
Marco Kalter
Allround Automations

[This message has been edited by mkalter (edited 05 April 2001).]