Insert/Update On Oracle to MS SQL Server Gateway
I have been successful in creating a gateway between Oracle and SQL Server.
Everything works fine for a Select Stmt.
But not for an Insert or Update,
I get a message about a "Read Only Cursor".
I have setup a HS_TRANSACTION_LOG table in the SQL Server DB. The user that I created the table with is the same as the user in the "tg4msql" file for recovery. The table has also been granted PUBLIC Access.
What am I missing?
MESSAGE:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]FOR UPDATE cannot be specified on a READ ONLY cursor.