TMySQLStoredProc provides full support for MySQL 5.0+ stored procedures.
TMySQLStoredProc allows to execute stored procedures in MySQL database. It supports IN, OUT and INOUT parameters.
TMySQLStoredProc is TDataSet descendant. So you can use it for store resultset fetched in stored procedure. TMySQLStoredProc also allows to execute stored procedures without storing resultset (for example, procedures with INSERT, UPDATE or DELETE statements).
You should use 'root' user account to be able to work with all stored procedures. If you're using other user account, then DAC for MySQL will fetch parameters of stored procedures created by this user only.