As a part of our requirement we are dynamically setting the select variables and table names to execute a select query using RDB-List . PRPC is unable to handle Errors or Exceptions if any invalid table names or Columns Names passed as parameter, though exception handling steps are mentioned in the activity.

It is observed from the tracer that the activity is getting terminated as soon as there is an error detected without performing exception steps.

It is not getting handled even when tried to catch the exception using listRDB method engine API method in a java step.

Please find attached the document with screen prints of the exception and the steps followed to fix these.

Please share how these can be addressed with proper exception handling.

Other relevant details -

1. PRPC version - 7.1.9

2. DB vendor - Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

3. Java Version - 1.8.0_112

Thanks,

Arka Bhattacharya