配好透明网关从oracle访问mysql的时候,有些特殊字段无法访问,如mysql的text字段:
SQL> select "ID","name","field1","field2","field3","sysactor","reference","layout","deled","description","createrid","state" from "actors"@mysql;
select "ID","name","field1","field2","field3","sysactor","reference","layout","deled","description","createrid","state" from "actors"@mysql
*
ERROR at line 1:
ORA-00904: "description": invalid identifier
description字段为text类型,访问的时候就报错。
去掉该字段,还是报错:
SQL> select "ID","name","field1","field2","field3","sysactor","reference","layout","deled","createrid","state" from "actors"@mysql;
ERROR:
ORA-28528: Heterogeneous Services datatype conversion error
ORA-02063: preceding line from MYSQL
原来oracle无法访问mysql的varchar、text和int等字段,那位大侠说下怎么直接访问这些字段,一样给赏啊。
mysql> desc actors;
+-------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| ID | decimal(11,0) | NO | PRI | 0 | |
| name | varchar(100) | YES | | NULL | |
| field1 | decimal(4,0) | YES | | NULL | |
| field2 | varchar(100) | YES | | NULL | |
| field3 | varchar(255) | YES | | NULL | |
| sysactor | int(4) | NO | | 0 | |
| reference | int(4) | NO | | 0 | |
| layout | varchar(100) | YES | | NULL | |
| deled | int(4) | NO | | 0 | |
| description | text | YES | | NULL | |
| createrid | int(11) | YES | | NULL | |
| state | int(4) | YES | | 1 | |
+-------------+---------------+------+-----+---------+-------+
12 rows in set (0.00 sec)
mysql>
作者: 听海★蓝心梦
发布时间: 2011-08-20