Pl/Sql Procedure Calls A Db2 Stored Procedure In A Loop - After A Number Of Calls ORA-1401 Occurs (Doc ID 370106.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for DB2 - Version 10.1.0.3 and later
IBM z/OS on System z
Oracle Transparent Gateway for DB2 - Version: 10.1.0.3IBM z/OS (OS/390)


Symptoms

Tests show a PL/SQL procedure calls a DB2 stored procedure in a LOOP. After 385 calls
the procedure fails with code ORA-01401.
The procedure use two arguments : one for input and one for output both
varchar2.
It was tested
With argument of 32000 byte , error occurs after 385 calls.
With argument of 100 byte, error occurs after 16385 calls.

The DB2 stored procedure simply moves the response argument and returns. No sql
command are done.

.
Verified by gateway trace

.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms