查看过程、函数源代码

SELECT text FROM user_source WHERE name='procedure_name|function_name';

删除过程

DROP PROCEDURE procedure_name;

删除函数

DROP FUNCTION function_name;