Pl/Sql Procedure Calls A Db2 Stored Procedure In A Loop - After A Number Of Calls ORA-1401 Occurs
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)
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms