My Oracle Support Banner

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 and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.
This problem can occur on any platform.
This issue occured in Forms 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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.