Hi,
I m trying to connect Oracle 12c to MS SQL (Gateway)
HTRAPORU column is NTEXT type on MS SQL
SELECT T.HTRAPORUTEXT, T.HTRAPORU,
T.DURUMID, T.LABOZELNOT, T.SGTARIHSAAT, T.LABKABULTARIHI, T.CALISMABASLAMATARIHI,
T.CALISMABITISTARIHI, T.ONAYTARIHI, T.RAPORTARIHI, T.SUBEID, T.KILITLI,
T.MIND, T.MAXD, T.REFD, T.IPTAL, T.ACIL
FROM HTEST@ESKIDB T
WHERE HTETKIKKARTID=122477901
ORDER BY CASE WHEN BARKODNO IS NULL THEN 1 ELSE 0 END, BARKODNO;
I get a query error from my SQL Developer saying:
ORA-00904: "T"."HTRAPORU": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 2 Column: 29
I tried to use, like "HTEST"@ESKIDB and "T.HTRAPORU" but Problem not resolved
Can anyone help me on this please?
Yasin Polat