DBMS_SQL with Forms 5

[Quoted] I've got a form which under 4.5 worked fine. After porting to 5.0, I had trouble with a forms bug which restricted the form to being run against the version of the RDBMS it was compiled with - previously it ran agains multiple versions. Oracle apparently knows about this bug.

The problem is that whenever I call DBMS_SQL.EXECUTE, I get an ORA-3113. I know what normally causes this error, and can't see any obvious connection with DBMS_SQL other than an incompatibility with Forms. Other stored packages / procedures work OK, and it doesn't matter what the parsed SQL statement is. Trace files are generated on the server with zero length. I've tried reinstalling and manually recompiling the server-side DBMS_SQL package to no avail.

Forms V 5.0
RDBMS 7.1.4, 7.1.6.2 Any ideas, anyone?

Jamie Keir

-- 
+--------------------+---------------+----------------------------+


| Oracle 7     DBA   | Digital Unix  | Jamie Keir                 |

| Developer*2000     | Windows NT 4  | jkerr_at_jameswatt.ac.uk      |

| PL*SQL             | AmigaOS 3     |                            |

|                    | C / C++       | Now if I could just get    |


| Alpha AXP          | M68040 Asm    | them to *pay* me for it... |


+--------------------+---------------+----------------------------+