Properly usage creation procedure with out parameter

Do you use MySQL database?

Yes I do

For example if you create output parameter with name last_id, add the following code at the end of your stored procedure:

SELECT LAST_INSERT_ID() INTO last_id

and call the procedure in the following way:

CALL my_proc(@a);SELECT @a;