There are times when you just want to ignore a certain type of DML, in our case it is DELETE.
You can use Shareplex's transformation feature to ignore a particular type of transaction, say DELETE. You may want to go through the Shareplex Admin Guide to configure the transformation routines to ignore DELETEs.
Here is an example of a transformation procedure call in which deletes are ignored:
You can use a transformation routine where all it does is sets a status flag to 0 when it encounteres delete.
CREATE OR REPLACE PROCEDURE srcdata.za02_emp_delete
(new srcdata.emp%ROWTYPE,
key srcdata.emp%ROWTYPE,
ret_code NUMBER,
ora_sid VARCHAR2,
src_host VARCHAR2,
status OUT NUMBER)
AS
BEGIN
STATUS := 0;
END;
/
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center