I doubt that any tool will be able to document the funtionailty of the procedure but tools like TOAD (www.toadsoft.com) do provide a schema documentation option (well it's in the paid for version anyway!)

HTH