we have 2 server :
1-sqlserver 2012 on windows 2012
2-oracle 11g on linux
we want to show information from table1 in sql server on oracle database and created database link between them
when i have a query like
"select ID,NAME from TABLE1" in plsql
i can see true result
but when i have a query like
"select ID,NAME,picimage from TABLE1" in plsql
i get these errors 1 ORA-03113:end-of-file on communication channel 2 ORA-03114:not connected to oracle
can anybody help me?
Most probably the IMAGE data type is not recognized by Oracle. It is DEPRECATED in SQL Server, convert the column to VARBINARY either in the query or in the table.
I highly recommend to convert it in the table, since NTEXT, TEXT and IMAGE data types will be removed from further versions of SQL Server. Microsoft recommends to use NVARCHAR(MAX), VARCHAR(MAX), VARBINARY(MAX) instead.
https://learn.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql