CatchAll Block Fails to Catch Error when Database Adapter with Insert Fails (Doc ID 1376874.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Goal

You have a composite with a BPEL process that uses a database adapter to do an insert to multiple tables with a parent-child relationship.  You observe that when the insert in the topmost parent table fails, it gives clear information with the unique key violation.  But when inserting in the second layer or third layer table, it gives fuzzy information about the fault and the fault is not caught by the catchAll block implemented in the process.  The fault received is likely to look like this:

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.