Home » Server Options » Replication » replication pack. error
replication pack. error [message #75497] Sun, 25 April 2004 03:08
ashokmote
Messages: 56
Registered: December 2003
Member
when i execute this package i am getting error.i have all valid packages .y i am getting this error.can any one help me.plz

SQL> sho user
USER is "REPADMIN"
SQL> exec dbms_repcat.add_master_database('scott_mg','ravi.oradba');

BEGIN dbms_repcat.add_master_database('scott_mg','ravi.oradba'); END;
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04068: existing state of packages has been discarded
ORA-04068: existing state of packages (RAVI.ORADBA) has been discarded
ORA-04067: not executed, package body "SYS.DBMS_REPCAT_UTL" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_RPC", line 1843
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 3743
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 1901
ORA-06512: at "SYS.DBMS_REPCAT", line 121
ORA-06512: at line 1
SQL>
Previous Topic: Usage of Materialized View
Next Topic: Oracle 8i User written Function calls from another package
Goto Forum:
  


Current Time: Thu Mar 28 21:17:07 CDT 2024