创建了Oracle到Sqlserver的透明网关,在ORACLE写select语句访问没问题,但在Oracle段创建表或insert语句时报错。
如:
select "acc_no","serv_type_id","exchange_id","serv_name" ...
from serv@charge ;
(此语句可返回数据,不报错)
但:
create table tmp_serv as
select "acc_no","serv_type_id","exchange_id","serv_name" ...
from serv@charge ;
或:
insert into tmp_serv
select "acc_no","serv_type_id","exchange_id","serv_name" ...
from serv@charge ; (其中tmp_serv的表结构与Sqlserver的serv几 乎一样)
却报错了,错误信息很笼统:‘大概就是ORACLE访问非ORACLE系统时返回错误......’
哪位高手,请指点迷津!! |