Declaration and emplementation of procedure
create or replace procedure myprocedure istype mysyn is record (aa varchar (20), bb number (20)); begin for mysyn in (select * from test2) loop insert into test2 @ mydblink (aa, bb) values (mysyn.aa, MYSYN.BB); end loop;
Test the procedure
. - - - - - - - - - - - - - - - - - - - - - - - -
