OraFAQ Forum: Forms » No changes to save error on oracle9iAS

Home » Developer & Programmer » Forms » No changes to save error on oracle9iAS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No changes to save error on oracle9iAS [message #79715]

Thu, 04 July 2002 14:28

JD.Dutt
Messages: 9
Registered: December 2001

Junior Member

I am running the form using oracle9iAS and browser IExplorer in HP UNIX environment.

I am getting a message "FRM-40405:No changes to save" even after the record is getting saved. I am having multiple database blocks in the form,but at any time only one database block is active.

I tried with forms_ddl('commit') command,it is not even saving the record.

This error message was not comming when ran in client server.

Pl anybody suggest a solution for this,urgent.

Thanks in advance.

Report message to a moderator

Re: No changes to save error on oracle9iAS [message #79719 is a reply to message #79715]

Thu, 04 July 2002 21:07

Ravi
Messages: 251
Registered: June 1998

Senior Member

you can do like this

:system.message_level := 5;
commit;
:system.message_level := 0;

let me know if this works

Report message to a moderator

Re: No changes to save error on oracle9iAS [message #79729 is a reply to message #79719]

Fri, 05 July 2002 08:47

JD.Dutt
Messages: 9
Registered: December 2001

Junior Member

Thanks For your response,
But not Working,
Can you give me any other solution.

Report message to a moderator

Re: No changes to save error on oracle9iAS [message #79735 is a reply to message #79719]

Fri, 05 July 2002 23:33

Ravi
Messages: 251
Registered: June 1998

Senior Member

Ok Dutt Try this one..
In the on-error trigger on form put this code.
if error_code = '40405' then
null;
end if;

let me know this works

Report message to a moderator

Previous Topic:	Message while running a procedure
Next Topic:	Re: FRM-40508 error solutions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 11:02:59 CST 2025