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
Messages: 74
Registered: October 2006
Location: Pakistan

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.
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?

[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
Messages: 21131
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:
  l_cur_level number := :system.message_level;
  go_block ('block_name');
  :system.message_level := 25;
  :system.message_level := l_cur_level;

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

Current Time: Thu Jul 27 19:49:36 CDT 2017

Total time taken to generate the page: 0.07621 seconds