Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Verifying that procedure input arguments are passed correctly

One way to verify input arguments is to display the value of the parameter on the Interactive SQL Messages tab 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 debugger to verify that procedure input arguments were passed correctly. See Lesson 2: Debug a stored procedure.