best proceed hoop lobs seer distributed databases

if emanate an seer dblink can't directly opening throw columns aim tables.

for instance, emanate dblink with:

create database couple test_link 
  bond targetuser identified evidence controlling 'databasesid';

after things like:

select column_a, column_b 
from data_user.sample_table@test_link

except buttress lob, following error:

ora-22992: can't throw locators comparison remote tables

this .

the same page suggests fetch values internal table, nonetheless is... kind messy:

create list tmp_hello 
as name column_a 
from data_user.sample_table@test_link

any ideas?

code1