Oracle Forms

After upgrading to Oracle 10.2.0.1 EE DB from Oracle 9i DB I receive the Forms message "Unable to allocate record buffer. Clear form to continue" when I perform an execute-query on any block with more than 50 rows.

This dialog box has an OK button. When I press it I receive the Error "FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06502". Upon pressing OK to that dialog box I receive the message "Query caused no records to be retrieved."

I realize this is probably a DB issue since it does not happen on a XE DB with the same data. I raised the flag in the DB forum but thus far I received one general answer that XE and EE db's are not the same, but no assistance was provided as to what I might look for to determine why XE works but EE does not (seems counter intuitive to me).

Again, this is a Forms error and I checked all DB logs and cannot find any hint of why this is happening. Also I have tried this on multiple workstations with the same results.

TIA for any help you can provide,
Ed.

Message was edited by:
edkocol