I develop an application to query a blob column from dblink ,but with oracle's limitation ,I can't query directly from dblink like that:
select id,blob_col from tab@dblink;
Then I tried to copy query data into collections using "apex_collection.create_collection_from_query_b" but the api can't load lob column, so I thought to use "update_member"...
It's too complex!
Is there some simple way to do that?