I am testing my Forms 6i application with the latest
patchset against the 8.0.6.3, 8.1.6.3, 8.1.7.4, 9.2.0.4
databases and I am suppressing this annoying error in the
form (by using a form level on-error trigger).
No matter what the database server version is and the
patch level, this forms error happens if there is nothing
to save. In your case, given that you are using 9iAS
forms services, I would check the database server patch
level and then the 9iAS patch level.
I think even then, you will see the same error message.
It is a level 5 error anyway.
hope this proves useful
Zafer AKTAN
Oracle DBA/Developer
On Mon, 11 Aug 2003 07:53:16 -0700, Robert D. Perry wrote:
> Thanks for your response. Since the problem did not exist before the
> server crash, my management does not want to suppress the error. They
> want to find out the cause and resolve it.
> "nobody" <nobody_at_nowhere.com> wrote in message news:<R2YYa.132730$rsJ.104646_at_news04.bloor.is.net.cable.rogers.com>...
>> 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 Wed Aug 27 2003 - 23:04:53 CDT
