FRM-40602 Occurs If User Updates a Data Block Item After Database Migration
(Doc ID 438662.1)
Last updated on APRIL 24, 2023
Applies to:Oracle Forms - Version 10.1.2.3.0 and later
Oracle Forms for OCI - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.
This issue occured in Forms 10.1.2.2.0 and after a migration from a 9i to a 10g database.
After migrating RDBMS from 9i to 10g and also Oracle Application Server (OAS) and Developer Suite from 9.0.x to 10.1.2.2.0.
When trying to update, insert and delete data from Forms after the upgrade, the user receives the following error:
FRM-40602 Cannot insert into or update data in a view.
The user has only select privledges, and the grants against these tables are assigned by using DBMS_SESSION.SET_ROLE('role').
The relevant updates are related to a table, and not a view. The failing table related to this problem also has a public synonym.
Database migration from 9i to 10g.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document