Select text from user_source where type='PROCEDURE and name='UR_PROC_NAME'

HTH

Srini