SELECT * FROM information_schema.parameters WHERE SPECIFIC_NAME = 'your_procedure';
SELECT param_list FROM mysql.proc WHERE db='your_database' AND name='your_procedure';