Home » Developer & Programmer » Forms » frm-40401 :i want to save more then one records .
frm-40401 :i want to save more then one records . [message #211086] Tue, 26 December 2006 03:23 Go to next message
lunate
Messages: 74
Registered: October 2006
Location: Pakistan
Member

hi all.
i want to save more then one records/rows in a table by pressing a button 'SAVe' once.

>i put the following in then when-button-pressed trigger.
go_block('blockname');
commit;
but it give me error 'frm-40401 : no chaneg to save ' many times(one after the othere) but stores the data in table at backend.

how can i set my trigger to store the record(created by a cursor) one by one in othere table by just pressing a button only one time.

i how can i solve this problem?
regards.

[Updated on: Tue, 26 December 2006 03:24]

Report message to a moderator

Re: frm-40401 :i want to save more then one records . [message #211111 is a reply to message #211086] Tue, 26 December 2006 07:11 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There are two ways which could help.

First, modify message level to a higher level before committing changes, and set it back when it is finished:
declare
  l_cur_level number := :system.message_level;
begin
  go_block ('block_name');
  :system.message_level := 25;
    commit;
  :system.message_level := l_cur_level;
end;

Another one is modifying the commit commnad:
go_block ('block_name');
standard.commit;
Previous Topic: OC4J Instance
Next Topic: primary key and alpha character set.
Goto Forum:
  


Current Time: Sat Dec 10 20:39:10 CST 2016

Total time taken to generate the page: 0.08624 seconds