How can you treat a JDBC error as an error and not a success?

[Elliott2]

So simply I have a custom flow designer action using JDBC Step that inserts data into an Oracle database, when there is an error on this insert, I need the action to be treated as a failure, not a success so I can perform error handling and then access this log shown in the screenshot for that error handling.

 However, the action doesn't have any access to this log as far as I can tell, can someone assist with this?

The best I can seem to do is test total rows = 0 and give a generic error that the insert failed for a nebulous reason, but I would really like to access this log specifically.

[SP22]

@Elliott2, In your output result screenshot, we can see there is a "Don't treat as error" option. Could you please uncheck it

[Elliott2]

No it can't be unchecked because its not an option that is shown anywhere in the step.

[SP22]

@Elliott2 , For testing purposes, you can disable the connection and credentials and test it.
- You can modify Service name (<sid>.<domain> ) in order to test. As Oracle driver will not query with the service name, only the SID

[Elliott2]

What do you mean? Switch from a connection and credential alias to an inline defined connection? It still doesn't let me set "Don't treat as error"

[Elliott2]

I don't understand what you're asking, my connection alias works fine normally, I just want to enhance error handling.