Data Type problem using Stored Procedures

[kluesi]

After Updating from ODAC 6.25 to 6.50 we have problems with the boolean data type in parameters of Stored Procedures calls.

We use some Stored-Procedure, for example
PROCEDURE SomeProc( aBoolParam in Boolean)

In ODAC 6.25 it was possible to call the procedure like this
var
StoredProc: TOraStoredProc;
begin
[...]
StoredProc .ParamByName('aBoolParam').AsInteger := 1;
StoredProc .ExecProc;
[...]
end;

The integer Value was interpreted as a boolean value.

In ODAC 6.50 it doesn't work anymore. I receive a
PLS-00306: wrong number or types of arguments in call to 'SomeProc' error.

I see that we did not use the correct datatype but it worked fine until 6.50.
Will we have to change our Procedure calls or is there another solution?

Thanks in advance.

[Plash]

We are working on this problem.

However we recommend to change your code. You can use the AsBoolean or Value properties:

Code: Select all

StoredProc.ParamByName('aBoolParam').Value := 1;