1 Reply Latest reply: Nov 7, 2012 11:56 PM by Kgronau-Oracle RSS

    Oracle ODBC Gateway SELECT from Sybase fails on large column

    tx103108
      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.