My Oracle Support Banner

FRM-40602 Occurs If User Updates a Data Block Item After Database Migration (Doc ID 438662.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle Forms - Version 10.1.2.3.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


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