DESCRIBE PROCEDURE returns a result set with the column BODY, which contains the procedure body in the original ($$ notation) format.