--查看all_source视图即可
select * from all_source
where text like ‘%存储过程名%‘;