测试环境,sqlplus登录后提示如下:
package body "SYS.DBMS_APPLICATION_INFO" does not exist
检查一下,package确实在,没有package body。
重新生成,执行:$ORACLE_HOME/rdbms/admin/dbmsapin.sql
SQL> @dbmsapin.sql
Package created.
create public synonym dbms_application_info for sys.dbms_application_info
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Grant succeeded.
SQL>
OK.