OraFAQ Forum: Streams & AQ » Error in DBMS_PROPAGATION_ADM.CREATE

Home » Server Options » Streams & AQ » Error in DBMS_PROPAGATION_ADM.CREATE_PROPAGATION in Oracle 8i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	dbms_aq.namespace_aq is not available in Oracle 8i.
Next Topic:	Please help me!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 08:48:06 CST 2025