This discussion is archived
12 Replies Latest reply: Apr 14, 2013 1:39 PM by indra budiantho RSS

Not able to insert data from cursor

1002925 Newbie
Currently Being Moderated
hi 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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points