How to write a dblink sql query to fetch images from a table when column data type is blob in remote oracle server ?

See more:

SQL

C#3.5

There is a seperate oracle database used for a system
That database contains a table named per_images that contains columns like image_id,parent_id ,table_name and image(data type is BLOB for image)

I wrote a windows service to fetch data from similar other tables using db link [a simple sql query for dblink: select userid,emailid from table_name@dblink.xyz.com and it's working fine]and insert / update some tables inside sql server database depending on any changes done in oracle database [I can fetch other data types like, datetime, varchar, numeric except BLOB data type]

If any one could try this issue, I am getting error if i execute dblink query for blob data type

What I have tried:

NOT WORKING: select image_id,parent_id ,table_name,image from table_name@dblink.xyz.com

WORKING: select image_id,parent_id ,table_name from table_name@dblink.xyz.com
here I removed blob type i.e. image, but that is what i required