SQL>
SQL> SELECT object_name, object_type, status
2 FROM user_objects
3 WHERE OBJECT_NAME IN ('TEST_PACK', 'CALL_TEST_PROC')
4 and rownum < 50
5 ORDER BY object_name, object_type;
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
CALL_TEST_PROC
PROCEDURE VALID
TEST_PACK
PACKAGE VALID
TEST_PACK
PACKAGE BODY VALID
SQL>