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 The TYPES might have the CHAR type and it needs to be modified as VARCHAR2. Whenever...