Because I am tried of typing so long merge commands. This is more simple: V_RESULT := F_MERGE ( 'select * from PERSON@old_db' ,'PERSON', 'ID' ); for L_I in 1..V_RESULT.count loop dbms_output.put_line( ...
I first reported my problem on StackOverflow as question thinking it was a usage problem on how to merge into oracle with a CLOB column ( https://stackoverflow.com ...