Problems with Package Wizard

[Stefan Heymann]

Hello Marco,

I have the following problems with the Package Wizard (DOA 3.4.2):

- The Oracle type "integer" is translated to the Delphi type "Double" (which makes it more difficult to access if you want to use integers)

- when you have equally named functions in PL/SQL (which become OVERLOADed functions in delphi), one with a CLOB and the other with a BLOB parameter, both become a TLobLocator parameter which leads to equal signatures.

- When there is an expression like

select count (*)

in the comments of the package (which become Delphi comments, bracketed with (* and *) ), the "*)" in the expression terminates the Pascal comment. You could for example change this to

select count ( * )

.

Regards

Stefan

 

[Marco Kalter]

The Oracle INTEGER datatype has a precision of 38 digits, which is beyond a 32 bit integer. If you want to use 32 bit integers in Delphi, you should use the Oracle PLS_INTEGER datatype for your parameters instead.

Thanks for the Count(*) tip, we will fix this in the next patch release.

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

 

[Stefan Heymann]

And what about the "equal signature" problem?

------------------

 

[Marco Kalter]

Oops, I missed that one. You can disable the "Generate overloaded methods" option of course. This way the Package Wizard will create a unique name for each overloaded function.

We will check if this problem can be prevented.

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