Home » Server Options » Streams & AQ » Delete Handler
Delete Handler [message #75754] Thu, 04 November 2004 07:17 Go to next message
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 Go to previous messageGo to next message
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;
icon7.gif  Re: Delete Handler [message #109194 is a reply to message #75756] Tue, 22 February 2005 18:19 Go to previous messageGo to next message
Tereza
Messages: 6
Registered: November 2004
Junior Member
Thanks so much...I thought no one knew how to do it...
I finally found my way back to this site..I will try this tomorrow at work..
Re: Delete Handler [message #111227 is a reply to message #75756] Mon, 14 March 2005 18:20 Go to previous message
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 ?!!!
Previous Topic: multiple destination
Next Topic: Single or multiple queues for Steams
Goto Forum:
  


Current Time: Thu Mar 28 11:35:05 CDT 2024