One thing I noticed when doing the MySQL and MariaDB split is that we utilize the EventProcessingHandlingMode enum for two uniquely different scenarios:

• SQL parsing
• Streaming event processing

Currently, the Oracle connector uses the same configuration for this, and this can introduce subtle issues when you want to fall on most streaming event failures, but you'd like to relax the SQL parsing failure or vice versa.

The proposal is to introduce a new configuration property:
schema.change.event.processing.handling.mode