Delete Handler [message #75754] |
Thu, 04 November 2004 07:17 |
Tereza
Messages: 6 Registered: November 2004
|
Junior Member |
|
|
Is is possible to create a separate delete handler that actually doe nothing...I only want Inserts and Updates to propagte and be applied to the destination.
Or can I just not set up a delete handler...I used the GUI to create the Data stream and didnt see a separation of the DML commands
|
|
|
Re: Delete Handler [message #75756 is a reply to message #75754] |
Thu, 11 November 2004 05:18 |
Ravi Kanth Perepu
Messages: 8 Registered: August 2004
|
Junior Member |
|
|
Hi Tereza,
Please use the following code to create a rule.
This would ensure that deletes are not applied.
BEGIN
-- Create the rule set
DBMS_RULE_ADM.CREATE_RULE_SET(
rule_set_name => 'strmadmin.complex_rules',
evaluation_context => 'SYS.STREAMS$_EVALUATION_CONTEXT');
-- Create the complex rule
DBMS_RULE_ADM.CREATE_RULE(
rule_name => 'strmadmin.no_delete_dml',
condition => ' (:dml.get_command_type() != 'DELETE');
END;
|
|
|
|
Re: Delete Handler [message #111227 is a reply to message #75756] |
Mon, 14 March 2005 18:20 |
youssef77
Messages: 5 Registered: March 2005
|
Junior Member |
|
|
This is how to create a rule and rule set ... but ... how to actually let the Apply process to use this rule when applying LCRs ?!!!
|
|
|