This discussion is archived
1 Reply Latest reply: Nov 7, 2012 9:56 PM by kgronau RSS

Oracle ODBC Gateway SELECT from Sybase fails on large column

tx103108 Newbie
Currently Being Moderated
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
AS
SELECT
col1,
col2.
long_column_causing_issue,
col4
FROM my_table@dblink;

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
#
HS_FDS_CONNECT_INFO=dblink
HS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.so
HS_FDS_TRACE_LEVEL=255

HS_LANGUAGE=american_america.we8iso8859p1
HS_NLS_NCHAR=UTF-8

HS_KEEP_REMOTE_COLUMN_SIZE=ALL
HS_NLS_LENGTH_SEMANTICS=CHAR

#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini


Please advise as to why select will work with LONG column but not when creating a MV.
Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points