OS: CentOS 5.8 64-bit
DB: Oracle XE 11gR1 64-bit
Gateway: Oracle Gateway for ODBC 64-bit
Database and gateway reside on same Linux Server.
Connecting to remote Sybase SQL Anywhere 10 server on WindowsXP.
Using SQL Anywhere 11 odbc driver and unixODBC driver manager on Linux server.
isql tool connects without any problems.
One LISTENER, service for db and gateway on same port.
As a reference, see this thread as a continuation of the closed thread at Oracle ODBC Gateway SELECT from Sybase fails on large column
In that referenced thread, the issue was resolved for a SELECT statement.
But now I get the same error when trying to create a materialized view using that same SELECT (see code below):
CREATE MATERIALIZED VIEW MV_FOR_ME
REFRESH COMPLETE ON DEMAND
Here is the initdblink.ora file:
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
# HS init parameters
# ODBC specific environment variables
Please advise as to why select will work with LONG column but not when creating a MV.