Package Wizard: Converting integers to Double?

[Roeland]

Hi,

When I use the package wizard for importing a package in delphi it converts all the fields who are Number(9) into Double? Why? Integers are capable of storing numbers from -2147483648 to 2147483647.

So why converting?

Roeland

 

[Marco Kalter]

What exactly do you mean by "fields"?

 

[Roeland]

I mean the Table Columns

 

[Marco Kalter]

How are the table columns related to the package?

 

[Roeland]

Allright, let me try to explain it again:

- In Delphi: Oracle -> Package Wizard, I can convert an Oracle package to a Delphi unit.
- The converted Package contains methods which parameters are defined as Table Column types. For example:

procedure Add_Test (p_Test_Id in Test.Test_Id%type,
                    p_Name    in Test.Name%type);

Now, when column Test_Id is defined as a Number(8) in table Test, the conversion generates an integer.
In Delphi:

procedure Add_Test (pTestId: Integer; pName: string);

When column Test_Id is defined as a Number(9) in table Test, the conversion generates an double.
In Delphi:

procedure Add_Test (pTestId: Double; pName: string);

I think that as long as the number has 9 digits or less the conversion should be an integer instead of a double.

Thanks,

Roeland

 

[Marco Kalter]

I checked this, and it is indeed a bug. The limit for an integer is indeed number(8) in the package wizard, instead of number(9). We'll fix it.

 

[Roeland]

Is this already been fixed?

If not, could you give a quick fix please. It's very annoying for me, and I guess it will be no trouble for you.

In fact, I think we have already spend more time debating about it then you will need to fix this.

Thanks,

Roeland

 

[Marco Kalter]

Can you let me know your Delphi version and Direct Oracle Access version so that I can check if we can upload a fix for you?

 

[Roeland]

Delphi 2007
DOA 4.1.1.0

Thanks,

Roeland