Forums Register Login

Retrieve Stored Procedure Code

+Pie Number of slices to send: Send
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?
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
Dave my savior. Thank you very much.
Water! People swim in water! Even tiny ads swim in water:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1039 times.
Similar Threads
OUT parameter
OracleCallableStatement Problem
Stored procedure question
Transaction Management Query
VARBINARY in sp -how-to
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 23:18:40.