Although all the statements in a procedure are captured and replicated to target, there may be statements that are not captured by shareplex when the procedureis called from a trigger event.
Unlike procedure which is is explicitly run by a user, application, or trigger, triggers are implicitly fired by Oracle when a triggering event occurs, no matter which user is connected or which application is being used.
Shareplex is designed not tocapture transactions from shareplex user and certain Oracles account like system, sys, etc.
Make sure the procedures or sql statements are not excuted from an Oracles trigger.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy