ODP connection terminated when AS400 client receives protocol error sqlcode -30000
(Doc ID 2391849.1)
Last updated on APRIL 14, 2022
Applies to:Oracle Database Provider for DRDA - Version 220.127.116.11 and later
Information in this document applies to any platform.
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.
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