Call Stored Procedure input output parameter

Call Stored Procedure input output parameter

This example will show you how to call Stored Procedure with one input and one output parameter. For this example we are using MySQL server and will call this procedure using MySQL Workbench (We can use any tool to call it)

  • Sample stored procedure:

  • To call stored procedure:

  • Output:

Call Stored Procedure input output parameter

  • And if you use below:

  • Output will be select statement result from the table as below:

 

Call Stored Procedure input output parameter

For more information please refer this link

Leave a Reply

Your email address will not be published. Required fields are marked *