rtsora broken??

From: Eric <nobody.noclan_at_bigfoot.com>
Date: 22 Jul 2003 07:17:14 -0700
Message-ID: <aaf50ac3.0307220617.5d6c497b@posting.google.com>

Hi,
Oracle 9i on HPUX 11.0 with Server Express.

Everything runs fine until a particular SQL Select (returning 900 columns into host variables) is executed in a sub program. so,

rtsora prog1.gnt
Within prog1 I have

          MOVE 'prog2' TO WS-V1.
          CALL WS-V1.
Within prog2 I have
          MOVE 'prog3' TO WS-V2.
          CALL WS-V2.
Within prog3 I have
           EXEC SQL
            SELECT a,b,c....
           END-EXEC

This fails with either a 'trashed stack' error, or a Micro Focus 114 error.

There seems to be no obvious reason for the failure, different diagnostic displays within the program seem to move the error around. It can fail on calls to SQLADR or SQLBEX or even 'MOVE 0 TO SQHARM(3)'

rtsora prog3.gnt

...runs successfully, which would seem to clear the SQL statement of any blame. Similarly, reducing the number of columns retrieved in prog3 and running from prog1 doesn't fix the problem.

The program structure and database design cannot be altered, so I have to try to fix what I've got.

Everything is compiled as 32 bit.

It seems that I'm hitting a size boundary somewhere, but I can't see it. Does anyone have any hints?

TIA Eric Received on Tue Jul 22 2003 - 09:17:14 CDT