Retrieve Stored Procedure Code

[Gregg Bolinger]

Is there a way to retrieve the actual sql code from a stored procedure in MySQL. Also, is there a way to get the names of all the stored procedures in a database without knowing them?

[Dave Vick]

Gregg
Check out the getProcedures method of the DatabaseMetaData class. It lloks like ti might return the actual code too.
hope that is what you were looking for.

[Gregg Bolinger]

Dave my savior. Thank you very much.