desc MyFunction

-- or --

Code:
SELECT TEXT FROM ALL_SOURCE
  WHERE OWNER='ME' AND NAME='MYFUNCTION';