Invalid Variant Type Conversion

[garrad]

I have used the Package Wizard to create a class containing a procedure which is based on a stored procedure of the type PROCEDURE procname(par1 IN NUMBER, par2 IN NUMBER, par3 IN NUMBER, par4 IN OUT NUMBER, par5 IN OUT VARCHAR2).

The resulting function as converted into Builder is void __fastcall procname(double par1 , double par2 , double par3, double &par4 , AnsiString &par5 ).

Is it possible to use Array DML with stored procedures? When I try to pass arrays to a stored procedure I get Invalid Variant Type Conversion.

 

[Marco Kalter]

I think array DML should be possible, though I must admit that I have never tried it with a package class that was generated through the Package Wizard.

You must enable the "Always use variants as parameters" option though. It seems that you have disabled this option, and this causes the conversion error when you pass a variant array.

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