we are migrating from windows forms10gr2 to unix forms11gr2. The "exec sql" calls that were working fine in forms10gr2 on windows server are throwing up frm-40735 - ora-306500 error in 11gr2 version running in unix. The exec sql issues an update statement to update another table in different schema2 in the same database while forms is logged in to anohter schema1. all the grants are in place and work because this exec sql call works if we run current windows 10gr2 version and fails if run upgraded unix forms11gr2 version. Hence I dont think underlying database is the issue.
Whatever I have read wrt ora-306500 does not throw any light.
any help is greatly appreciated.