CAN ANY ONE HELP ? PLZZZZZZ [message #86435] |
Wed, 29 September 2004 21:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
domingo
Messages: 54 Registered: June 2004
|
Member |
|
|
I have a problem on a form that I need to correct .
When multiple rows are entered commit does not work.
The commit will work when 1 row is entered and then committed.
How to make commit work when multiple rows are inserted
thanks
Domingo
|
|
|
|
|
Re: CAN ANY ONE HELP ? PLZZZZZZ [message #86463 is a reply to message #86435] |
Fri, 01 October 2004 12:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
sai krishna
Messages: 8 Registered: July 2001
|
Junior Member |
|
|
hello...
clearly post a form picture which ur trying to insert multiple rows......
if ur inserting through block..
then
use the loop condition.....
before going to block count the no of records in block..
then use this condition
go_block('blockname');
first_record;
loop
for i 1..n
insert into(values);
next_record;
end loop;
thank u.
sai..
|
|
|