My Oracle Support Banner

ODP connection terminated when AS400 client receives protocol error sqlcode -30000 (Doc ID 2391849.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Database Provider for DRDA - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

The client detected a protocol violation, sqlcode -30000 and sqlstate 58,
EXECUTION FAILED DUE TO A DISTRIBUTION PROTOCOL ERROR,
when trying to return parameters from Oracle's stored procedure back to AS400 (DB2/400 v7.1).

ODP did not fail and the trace shows a procedure call with 5 parameters that are all INOUT type
and of datatype VARCHAR2, and each separate ODP request executed successfully
but the connection was terminated when the client received sqlcode -30000.

The SQLCODE -30000 indicates an anomaly (short field length) was detected in the response data, but that the session continues.

 

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.