select * from all_objects where object_type = 'PROCEDURES' and object_name = 'FTR_PROC'
SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE' AND OBJECT_NAME = 'FTR_PROC'
In Oracle, table names and field names are case-insensitive, unless you put quotes around them (as in
"all_objects"). Therefore there should be no difference between all_objects and ALL_OBJECTS.
The reason you are getting different results with the above two queries is probably because in the first one you refer to
'PROCEDURES' instead of