Overview
An Application containing a Managed Adapter that calls a Stored Procedure on Oracle in order to Update or Insert records in a database table works fine in SBM 2015 SP1.
After migrating the application to Aurea Process 2020 R1 and redeploying, the adapter suspends when it is run.
The Bizlogic Log shows this:
Caused by: java.sql.SQLException: ORA-06550: line 1, column 69:
PLS-00103: Encountered the symbol "" The symbol "" was ignored.
The Log for the application's managed adapter shows this:
DBAdapter.executeStoredProcedure(): Registering output parameters of following types: [SIBJMSRAThreadPool : 6]
Name: RETURN_CURSOR Type: Object [SIBJMSRAThreadPool : 6]
Found an output parameter with name 'RETURN_CURSOR'. No registerOutParameter() call made for this parameter. [SIBJMSRAThreadPool : 6]
Solution
When facing this error after an upgrade, the solution is to completely remove the Adapter and recreate it from scratch.