SQL> SELECT name, type 2 FROM user_dependencies 3 WHERE referenced_name = UPPER('&object_name') 4 AND referenced_type = UPPER('&object_type') 5 and rownum < 2 6 ORDER BY name;