"Error converting data type A to B"

Executing a certain stored procedure is successful in PowerBuilder but gives an "Error converting data type A to B" error message on the Web, where A and B stands for different data types.

Cause: The procedure contains an output parameter that is A, but the corresponding variable used to call the procedure is a B. JDBC driver may handle such a case differently from the ODBC driver or native driver used in PowerBuilder.

Solution: Make sure the type of the calling variable is exactly the same as the type of the output parameter.