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 FEBRUARY 05, 2019

Applies to:

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


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
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



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.