| How to save multiple records at once? [message #586093] |
Mon, 03 June 2013 07:00  |
 |
oraclehi
Messages: 41
Registered: July 2012
Location: India
|
Member |
|
|
how to save multiple records at once i did coding like this:
declare
cnt number;
l_rec number;
f_rec number;
begin
cnt := 0;
go_block('aan');
last_record;
l_rec := :system.cursor_record;
first_record;
f_rec := :system.cursor_record;
go_block('aan');
for v in f_rec..l_rec loop
update aan set pan=:aan.pan where aan=:aan.aan;
cnt := cnt+1;
next_record;
end loop;
first_record;
commit_form;
end;
exit_form;
but this works as saving the last record only, not saving the all records.
how to do this??
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
