CODE EXAMPLE FOR SQL

Mysql get routine parameter list

SELECT param_list FROM mysql.proc WHERE db='your_database' AND name='your_procedure';