TRY IT .. SELECT * FROM ALL_OBJECTS WHERE OWNER = UPPER('YOUR_SCHEMA_NAME') AND OBJECT_TYPE = UPPER('PROCEDURE') AND OBJECT_NAME = UPPER('YOUR_PROC_NAME');
SELECT * FROM ALL_PROCEDURES WHERE OBJECT_NAME = UPPER('YOUR_PROC_NAME') ;
select * from user_objects where object_type = 'PROCEDURE' ----'PROCEDURE'是字段值,大字.
SELECT *
FROM ALL_OBJECTS
WHERE OWNER = UPPER('YOUR_SCHEMA_NAME')
AND OBJECT_TYPE = UPPER('PROCEDURE')
AND OBJECT_NAME = UPPER('YOUR_PROC_NAME');
SELECT *
FROM ALL_PROCEDURES
WHERE OBJECT_NAME = UPPER('YOUR_PROC_NAME')
;