Home » Server Options » Streams & AQ » Error in DBMS_PROPAGATION_ADM.CREATE_PROPAGATION in Oracle 8i
Error in DBMS_PROPAGATION_ADM.CREATE_PROPAGATION in Oracle 8i [message #195330] Thu, 28 September 2006 01:20
ask4shailesh
Messages: 4
Registered: September 2006
Location: mumbai
Junior Member
Hi,

I need to propagate message from queue in Oracle 8i to queue in Oracle 9i.
From Oracle 9i, I am able to propagate message by creating subscriber and creating propagation by
DBMS_PROPAGATION_ADM.create_propagation.
I am using same steps to propagate message from queue in Oracle 8i to queue in Oracle 9i.

However, Following code is giving error :

BEGIN
DBMS_PROPAGATION_ADM.create_propagation(
'prop_name',
'queue_src',
'queue_dest',
'TEST_DB_LINK');
END;

error =
ORA-04068: existing state of packages has been discarded.
ORA-04063: package body "SYS.DBMS_PROPAGATION_ADM" has errors
ORA-06508:PL/SQL: could not find program unit being called

Your thoughts are appreciated.

Thanks,
Shailesh
Previous Topic: dbms_aq.namespace_aq is not available in Oracle 8i.
Next Topic: Please help me!
Goto Forum:
  


Current Time: Thu Mar 28 17:22:26 CDT 2024