UniDAC 6.2.8 - exceptions during stored procedures with output parameters execution

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dJabber
Posts: 3
Joined: Thu 26 Sep 2013 10:43

UniDAC 6.2.8 - exceptions during stored procedures with output parameters execution

Post by dJabber » Tue 29 Sep 2015 10:04

Hello.
Database - IBM DB2 LUW 10.5

During the execution of stored procedures with output parameters I have exceptions,
but when I explicitly assign ParamType to ptInputOutput instead of ptOutput - exception does not appear.

To reproduce - created the stored proc with output parameter, put TUniconnection component on VCL Form, assign connection parameters, set Connected=true, put TUniStoredProc on VCL form, assign connection, assign stored proc name.
Now we can see, that UniDAC automatically assignes parameter type ptOutput to the output parameter of tored proc.
Put the button on VCL Form, in OnClick handler put storedproc.Execute (or ExcecProc), then execute application. When you press button - the exception message appears.

In 6.1.6 UniDAC version the default code works.

Developers, could you please clarify the situation?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: UniDAC 6.2.8 - exceptions during stored procedures with output parameters execution

Post by MaximG » Wed 30 Sep 2015 11:50

Thank you for the information. We have reproduced the issue, and we will inform you about the results shortly.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: UniDAC 6.2.8 - exceptions during stored procedures with output parameters execution

Post by MaximG » Wed 07 Oct 2015 10:34

Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next UniDAC build.

Post Reply