My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle API Gateway - Version 11.1.2.1.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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