UniDAC 6.2.8 - exceptions during stored procedures with output parameters execution
Posted: 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?
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?