Gateway Failing With Pl/SQL Numeric Or Value Error: character string buffer too small (Doc ID 2080351.1)

Last updated on AUGUST 01, 2023

Applies to:

Symptoms

On an upgrade of the API Gateway to 11.1.2.3, failures in the Gateway are experienced when calling pl/sql procedures which use IN/OUT parameters.
If the attribute specified as the IN/OUT parameter has not previously been set to a value in the Gateway then, immediately following the procedure call, the Gateway errors out with the below message:

com.vordel.common.VordelException: Error performing the query [BEGIN
<SCHEMA>.<PACKAGE>(?);
END;]: SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 2
at com.vordel.common.db.WildcardedCallableStatement.execute(WildcardedCallableStatement.java:127)
at com.vordel.circuit.attribute.AttributeExtractDbProcessor.getAttributes(AttributeExtractDbProcessor.java:159)
at com.vordel.circuit.attribute.AttributeExtractDbProcessor.getAttributes(AttributeExtractDbProcessor.java:145)
at com.vordel.circuit.attribute.AttributeExtractBaseProcessor.invoke(AttributeExtractBaseProcessor.java:149)
at com.vordel.circuit.attribute.AttributeExtractDbProcessor.invoke(AttributeExtractDbProcessor.java:80)
at com.vordel.circuit.InvocationEngine.invokeFilter(InvocationEngine.java:150)
at com.vordel.circuit.InvocationEngine.invokeCircuit(InvocationEngine.java:42)
at com.vordel.circuit.InvocationEngine.recordCircuitInvocation(InvocationEngine.java:276)
at com.vordel.circuit.InvocationEngine.processMessage(InvocationEngine.java:239)
at com.vordel.circuit.SyntheticCircuitChainProcessor.invoke(SyntheticCircuitChainProcessor.java:64)
at com.vordel.dwe.http.HTTPPlugin.processRequest(HTTPPlugin.java:351)
at com.vordel.dwe.http.HTTPPlugin.invokeDispose(HTTPPlugin.java:359)
at com.vordel.dwe.http.HTTPPlugin.invoke(HTTPPlugin.java:135)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.