Stored procedure parameter

If the output parameter of stored procedure has default values, even if PowerBuilder did not pass the output parameter, the server can still use the default value of the stored procedure to successfully get data. However, in PowerServer, if PowerBuilder did not pass the output parameter, PowerServer will use null as the default value. This will cause the result set different between PowerBuilder and PowerServer.

If the parameter name or number does not match, PowerBuilder will display an error indicating that the parameter does not exist; while PowerServer will check the schema of stored procedure or function and automatically match the corresponding parameter type and position, therefore PowerServer may be able to execute the stored procedure without errors.