Re: FRM-40401 Error

raise your message level and ignore

FRM-40401: No changes to save.

Cause:No records were added or modified since the last apply or save.

Action:No action is necessary.

Level:5

Type:Error

"Robert D. Perry" <rdperry_at_gowebway.com> wrote in message news:e4fbf364.0308080530.7d5160bf_at_posting.google.com...
> We are experiencing FRM-40401 errors in our production environment.
> When we save data through the application, it is save to the
> appropriate table in the database and we get a confirmation that the
> data was saved. If the end user tries to navigate to another record
> or form, the FRM-40401 error pops up asking do we want to save the
> data. When the user pressed the button to save again, the application
> responds that there is no data to save. As I stated earlier, the data
> has been saved to the database on the initial save.
>
> Our developer(former Oracle Forms Instructor & has reviewed the
> suggestions on Metalink) is stumped and it appears that the Oracle
> Forms support is too. We are using Oracle 9ias Release 1 with Forms
> 6i. This problem is only experienced in the production environment.
> Development & Test do not have this problem. We see this problem both
> on the app server and connecting directly to the database from a
> desktop PC.
>
> After a server crashed in May, our production database was moved to
> another server. At this point, the pop ups began. We believe the
> problem resides on the database side. Has anyone experienced this
> problem found a solution by making a change on the database side?
>
> If so, please respond to rperry_at_fleetcor.com
>
> Thanks
Received on Fri Aug 08 2003 - 20:24:01 CDT