FRM-40654 Oracle 9i

[Paolo]

Hi, i've got a problem with 2 forms; the problem happens after
upgrading from oracle 8i to 9i, i still use oracle client 6 (patch 7).
Two examples:
1. Open the form A, insert required data and commit. Then i try to
delete the same record and application return the error 40654 telling
me to requery to see the changes.
2. Open the form A, insert required data and commit. From the form A
open the form B, insert required data in form B and commit: i've got
the same errore 40654.

If i try these steps with an 8i database everything works fine.

Are there some properties in form that is necessary to change if i use
9i? Maybe is there an oracle bug?
Any suggestion is appreciate!!!
Thanks

[DA Morgan]

Paolo wrote: Hi, i've got a problem with 2 forms; the problem happens after upgrading from oracle 8i to 9i, i still use oracle client 6 (patch 7). Two examples: 1. Open the form A, insert required data and commit. Then i try to delete the same record and application return the error 40654 telling me to requery to see the changes. 2. Open the form A, insert required data and commit. From the form A open the form B, insert required data in form B and commit: i've got the same errore 40654. If i try these steps with an 8i database everything works fine. Are there some properties in form that is necessary to change if i use 9i? Maybe is there an oracle bug? Any suggestion is appreciate!!! Thanks

I think the problem is Patch 7. Get Forms patched up to the
appropriate level and the problem should go away.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)