My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.