Re: FRM-40654 Oracle 9i

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_at_x.washington.edu
(replace x with u to respond)