When invoking a Stored Procedure through the JCA DB Adapter, getting an ORA-02089 Error (Doc ID 1969044.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle Service Bus - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.7.0 version, OSB Transports

Proxy Service -> Business Service -> JCA DB Adapter -> Oracle DataBase Stored Procedure1 -> Oracle Database Stored Procedure 2 -> Database Table to insert

When attempting to test this flow the following error occurs.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms