查询用户下的存储过程 select object_name,object_type,status from user_objects where OBJECT_TYPE='PROCEDURE'; 查询存储过程内容 SELECT text FROM user_source WHERE NAME = 'procedure_name' ORDER BY line ;