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