Not able to insert data from cursor
1002925Apr 14 2013 — edited Apr 14 2013hi everyone,
i am using oracle forms 6i and 10g database.
i have two table in database table_a and table_b
in forms 6i i have created cursor for selecting data from table_a and trying to insert data in table_b.
my code is something like this.
-------------------------------
cursor c1 is select col1, col2, col3, col4
from table_a
where col1 = condition....
begin
FOR I IN C1
LOOP
insert into table_b
(col1, col2, col3, col4 )
values (val1, val2, val3, val4);
END LOOP;
commit;
end;
----------------------------
any help will be greatful.