OraFAQ Forum: Forms » frm-40401 :i want to save more then one records .

Home » Developer & Programmer » Forms » frm-40401 :i want to save more then one records .

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

frm-40401 :i want to save more then one records . [message #211086]

Tue, 26 December 2006 03:23

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

Littlefoot
Messages: 21818
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;

Report message to a moderator

Previous Topic:	OC4J Instance
Next Topic:	primary key and alpha character set.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:34:37 CDT 2024