;  Table renamed.  SQL> select object_type, status from user_objects where object_name = 'PKG_TEST';  OBJECT_TYPE         STATUS ------------------- ------- PACKAGE             VALID PACKAGE BODY        VALID  SQL> select pkg_test.f_right_now from dual;  F_RIGHT_NO ---------- 0000-00-00  SQL> 