I am facing SQLCODE -905 with Declare Global Temporary Table (i.e. DGTT)
In a stored procedure we fetch data from multiple tables using a multifetch. This data is inserted into a DGTT and then it is passed to a different stored procedure for generating a report. We faced an issue when the number of records fetched were = 12597.
The stored procedure executed for a very long time and finally it failed with SQLCODE -905.
Has anyone faced this issue before? If yes,can you please suggest a work around?