| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
