3 Replies Latest reply: Dec 10, 2012 11:47 AM by Andreas Weiden RSS

    Retrieving records from a Data Block same as retrieving records from cursor

    RiyasDev
      Dear Gurus,

      Is it possible to retrieve records from a datablock same as retrieving records from a cursor,

      Eg:

      I am having two data blocks in two different tabs, Say B1 in Tab1, B2 in Tab2

      B1 is filled with two records, now when I switch to Tab2,

      I want all records of B1 in B2, assuming that blocks are having the same structure.

      The code I wish to write is,

      Goto B1,
      Take all the records like a cursor,
      Goto B2,
      loop
      insert
      end loop;

      Is this possible???