This discussion is archived
1 Reply Latest reply: Jan 19, 2013 10:14 PM by yoonas RSS

diference in "exec sql" call between forms 10gr2 and 11gr2?

102992 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points