select text from user_source where name='PROCEDURE_NAME'

HTH

Srini