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 laterOracle Forms for OCI - Version 12.2.1.4.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.
Symptoms
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:
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.
Changes
Database migration from 9i to 10g.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |