This discussion is archived
3 Replies Latest reply: Dec 10, 2012 9:47 AM by Andreas Weiden RSS

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

RiyasDev Newbie
Currently Being Moderated
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???

Legend

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