SOA BPEL With JCA Exception

When we execute the BPEL getting the below error -

[BEA][Oracle JDBC Driver][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 7
weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
weblogic.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)


Versions: SOA 12.1.3 and SOA 12.2.2

Analysis 

Step 1. JCA adapter will create a wrapper API'S at corresponding database if the actual API contains some special type declarations (Ex: TableType etc) 

Step 2. We need to understand this particular error is happening because of the wrapper API's created at DB.

Step 3. Make sure all the wrapper related API's and TYPES should get the required GRANTS for the user.

Solution 

1. The TYPES might have the CHAR type and it needs to be modified as VARCHAR2. Whenever any of the element is created with CHAR then it needs to be adjusted as a VARCHAR2. 

2. Now drop the TYPE from DB. It may be needed to drop all the dependencies as well.

3. Re-create the modified TYPE and provide all the GRANTS.

This will solve the above issue !! Enjoy ..