how to retreive the parameters of the stored procedures fro information_schema

[meyyappan ramu]

Hi all,

I want to know how to retreive the In,Out parameters of the stored procedures in mysql(It is possible in oracle and sql server).I am using a java program to retreive parameters of the stored procedures,but i want to get it by querying the database ,is that possible,if so how it is possible.please give the query.

I tried to access it from information_schema through the query browser.there is a table called routines which gives the information about the stored procedures,such as name of the procedure,query used ,etc.,

for example u can try executing the below given query

SELECT * FROM information_schema.ROUTINES R;

it will return the result set with procedure information as said above.but no field is available to get the parameters of particular procedure.If any one knows the query which returns the parameter of the stored procedure,i will be really greatful to u all.