Verifying procedure input arguments are passed correctly

One way to verify input arguments is to display the value of the parameter in the dbisql Messages pane (or the message window of the server) using the MESSAGE statement. For example, the following procedure simply displays the value of the input parameter var:

CREATE PROCEDURE message_test (IN var char(40)) 
BEGIN 
	MESSAGE var TO CLIENT;
END

You can also use the stored procedure debugger.