MySQL longtext columns in Oracle via DB Links
Hi Guys,
I followed Connecting Oracle to MySQL Using DG4ODBC Database Link [ID 1320645.1] from metalink and here's my HS configuration
Server 1: RHEL 5.5 64 bit
Oracle DB: 11.2.0.2.0 64 bit
ODBC: unixODBC 2.2.14 64 bit
MySQL Connector: 5.1.10 64 bit
Server 2: RHEL 4 64 bit
MySQL DB: 5.0.45 64 bit
My odbc.ini
HS_FDS_CONNECT_INFO = myodbc5
HS_FDS_TRACE_LEVEL = ON
HS_FDS_TRACE_FILE_NAME = /export/home/oracle/app/hsodbcsql.trc
HS_FDS_SHAREABLE_NAME = /export/home/oracle/app/unixodbc-2.2.14/lib/libodbc.so
HS_FDS_SUPPORT_STATISTICS = FALSE
HS_FDS_FETCH_ROWS = 100
HS_LONG_PIECE_TRANSFER_SIZE = 1048576
HS_LANGUAGE=AL32UTF8
HS_NLS_NCHAR=UCS2
HS_FDS_REMOTE_DB_CHARSET=KO16KSC5601
HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
I successfully configured HS and created DB link from Oracle DB to MySQL DB and I able to query the MySQL tables from Oracle SQLPlus using the DB links.
Few of my tables in the MySQL database has longtext datatype columns.
When I try to query these columns from Oracle environment I am getting ora-904: Invalid identifier error.
When I described those tables in the Oracle environment those columns are not listed at all.
I read through http://docs.oracle.com/cd/E11882_01/gateways.112/e12070.pdf and spent all morning searching for a solution and finally gave up.
Is there any restriction in Oracle gateway interface that does not allow accessing longtext datatype columns from MySQL database? Is there a way to access that data. If I understand those columns should be mapped to RAW or BLOB. How can achieve this mapping?
Let me know if I should be sharing any other details.
Thank you for your inputs.
Balaji