How to prepare an insert script from pl/sql procedure

[hacketta1]

You want a generic procedure that will copy a table from one database to another as I understand it. Look into EXECUTE IMMEDIATE, CREATE TABLE AS SELECT, and DATABASE LINKS.

e.g.

create database link
create table y as select * from y@dblink