数据库8.1.5下产生DBMS_RANDOM时有错误

显示全部楼层 · 2005-10-30 17:05:33

SQL> @dbmsrand.sql
Package created.

Warning: Package Body created with compilation errors.

Synonym dropped.
DROP PUBLIC SYNONYM dbms_random

*
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist

Synonym created.
CREATE PUBLIC SYNONYM dbms_random FOR sys.dbms_random

*
ERROR at line 1:
ORA-00955: name is already used by an existing object

Grant succeeded.

Grant succeeded.
发现编译有问题导致不能调用DBMS_RANDOM
SQL> selectdbms_random.random() from dual;
selectdbms_random.random() from dual
*
ERROR 位于第 1 行:
ORA-04068: 程序包的现有状态已被丢弃
ORA-04063: package body "SYSTEM.DBMS_RANDOM" 有错误
ORA-06508: PL/SQL：无法在调用之前找到程序单元
ORA-06512: 在line 1
谢谢

千问 · 2005-10-30 17:05:33

谢谢

千问 · 2005-10-30 17:05:33

是包体里有错误!