in reply to Re: DBD:Oracle::db prepared error
in thread DBD:Oracle::db prepared error

Just to add a little more detail to Joost's comment:

create an array of column names (if columnnames in DB1 eq columnnames in DB2) , then use that array to build the select and load statements.

If columnnames in DB1 ne columnnames in DB2 then use a hash to show the correspondance and build the select and load statements from the keys/values of the hash.

-------------------------------------
Nothing is too wonderful to be true
-- Michael Faraday