2011/3/31 Samiran Raj Boro srajbr@gmail.com:
Using information_schema is preferred way.
But I think using mysql.proc for just reading the values won't harm anything. Moreover MySQL java driver (Connector/J) uses mysql.proc.
information_schema is an ANSI standard and should be used instead of DBMS specific extensions whenever possible. It will also make Drizzle support easier to implement, as they have dropped mysql database.