12 Replies Latest reply: Apr 14, 2013 3:39 PM by indra budiantho RSS

    Not able to insert data from cursor

      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....

      FOR I IN C1
      insert into table_b
      (col1, col2, col3, col4 )
      values (val1, val2, val3, val4);
      END LOOP;


      any help will be greatful.