Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Here,

apply_old_data : the values at the target, queried by using key columns in the where clause. The boolean flag indicates whether any such record was found.

primary_key_data: old values at the source; mostly used to see the key, but it actually contains all supplementally logged values, too. Thus it will always (excl. LOBs, LONGs) include the modified column, too.

new_data: new (modified) values at the source.

The return values are:

  • 0: discardDiscard
  • 1: overwriteOverwrite
  • 2: retryRetry
  • 3: the The PL/SQL function resolved the conflict by itself and made all necessary changes.
  • 4: Force

The function must not issue a commit, as the transaction may be yet rolled back, if a rollback happened on source.

...