Hello,
Using HS to connect from oracle 10204 to MySql 5
Running the following statment using dblink from oracle:
SELECT * From "Custom_XDR"@MySql
After setting a trace level ON on the getway server , the trace file shows that all the varchar column are skipped !
ORACLE GENERIC GATEWAY Log File Started at 2011-02-08T11:17:42
hoadtab(26); Entered.
Table 1 - Custom_XDR
Skipped field h323_conf_id, unrecognized datatype.
Skipped field user_agent1, unrecognized datatype.
Skipped field user_agent2, unrecognized datatype.
Skipped field ip1, unrecognized datatype.
Skipped field ip2, unrecognized datatype.
Warning: index h323 is ignored.
hoapars(15); Entered.
Sql Text is:
SELECT A1."id",A1."bill_time",A1."i_env",A1."last_modified1",A1."last_modified2" FROM "Custom_XDR" A1
The table strucher in Mysql is as followed:
SQL> desc Custom_XDR
+----------------+-------------------------+-----+----+---------------------+-----------------+
| Field | Type | Null| Key| Default | Extra |
+----------------+-------------------------+-----+----+---------------------+-----------------+
| id | int(10) unsigned | NO | PRI| | auto_increment |
| h323_conf_id | varchar(36) | NO | MUL| | |
| bill_time | datetime | NO | | | |
| i_env | tinyint(1) unsigned | NO | | | |
| user_agent1 | varchar(50) | NO | | | |
| user_agent2 | varchar(50) | YES | | | |
| ip1 | varchar(15) | NO | | | |
| ip2 | varchar(15) | YES | | | |
| last_modified1 | timestamp | NO | | 0000-00-00 00:00:00 | |
| last_modified2 | timestamp | NO | | 0000-00-00 00:00:00 | |
+----------------+-------------------------+-----+----+---------------------+-----------------+
Please advice.
Thanks