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 AUGUST 01, 2023

Applies to:

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


On an upgrade of the API Gateway to, 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
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(
at com.vordel.circuit.attribute.AttributeExtractDbProcessor.getAttributes(
at com.vordel.circuit.attribute.AttributeExtractDbProcessor.getAttributes(
at com.vordel.circuit.attribute.AttributeExtractBaseProcessor.invoke(
at com.vordel.circuit.attribute.AttributeExtractDbProcessor.invoke(
at com.vordel.circuit.InvocationEngine.invokeFilter(
at com.vordel.circuit.InvocationEngine.invokeCircuit(
at com.vordel.circuit.InvocationEngine.recordCircuitInvocation(
at com.vordel.circuit.InvocationEngine.processMessage(
at com.vordel.circuit.SyntheticCircuitChainProcessor.invoke(
at com.vordel.dwe.http.HTTPPlugin.processRequest(
at com.vordel.dwe.http.HTTPPlugin.invokeDispose(
at com.vordel.dwe.http.HTTPPlugin.invoke(



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

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