Home » Server Options » Replication » Replication XML
Replication XML [message #75465] Wed, 18 February 2004 06:57
pg
Messages: 12
Registered: May 2002
Junior Member
Hi,

I m working in a multi-master replication environment with 2 sites: I ve two master groups:

the first one uses asyncronous propagation (SITE 1 TO SITE 2) for a set of tables the other one syncronous propagation for one table called

COMMAND_TABLE for example (SITE 2 TO SITE 1).

I ve a TRIGGER on COMMAND_TABLE of SITE 1 :

This is trigger code:

CREATE OR REPLACE TRIGGER "AV_SGRT"."TR_SGRT_ACI_INTERFACE" AFTER

INSERT ON "AV_SGRT"."TA_SGRT_ACI_INTERFACE" FOR EACH ROW

DECLARE

result number;

BEGIN

<DIR>
<DIR>

...

result := :new.c_xml_data.existsNode('//prog');

....
</DIR></DIR>

END;

/

c_xml_data is a XMLTYPE

This is the scenario:

step 1 : INSERT on COMMAND_TABLE of SITE 2

Error occurs:

ORA-30625: method dispatch on NULL SELF argument is disallowed

ORA-06512: at "AV_SGRT.TR_SGRT_ACI_INTERFACE", line 26

ORA-04088: error during execution of trigger 'AV_SGRT.TR_SGRT_ACI_INTERFACE'

ORA-02063: preceding 3 lines from ACINOVE

Why?

If I execute the same insert command directly on SITE 1 it s OK

Thanks in advance
Previous Topic: Oracle remote small database
Next Topic: Where calls of a defered transaction in deferror are stored?
Goto Forum:
  


Current Time: Thu Mar 28 12:48:27 CDT 2024