Hello,
I am having trouble returning large integer values from Oracle package functions using direct oracle access and the package wizard.
For example, I made this test:
procedure Test
(
Param1 out Integer
) is
begin
Param1 := 9223372036854775808;
end Test;
The package wizard interprets Integer as a float and uses the Double data type in Delphi (as I guess underneath an Integer in Oracle == Number(38)) and even if I could get past the wrongness of "storing an integer in a float data type", a double doesn't have enough significant digits to represent large 64 bit numbers anyway. If I tell the package wizard to use variants, it just returns a double in a variant. I'd like something like PLS_INTEGER, which the wizard uses otInteger for, but this is only 32 bits..
Thanks for any info/help,
David