SQL>select * from user_objects where OBJECT_TYPE = 'PROCEDURE';

SQL>set long 10000

SQL>select text from user_source

where NAME = '프로시져명';