Giuseppe Maxia <gmax_@_cpan_._org> wrote:
> I was trying to do exactly the same thing, and I found out that the
> only viable solution, as of today, is to parse the output of
> "SHOW CREATE FUNCTION ..." in the host language.
>
> Quoting from the manual:
> "INFORMATION_SCHEMA does not yet have a PARAMETERS table, so applications
> that need to acquire routine parameter
> information at runtime must use workarounds such as parsing the output of
> SHOW CREATE statements."
> http://dev.mysql.com/doc/refman/5.0/...trictions.html

Just for the record, I find that parsing mysql.proc.param_list is easier,
though still a workaround.

Yours,
Laurenz Albe