sql插入oracle链接的数据

时间:2023-03-09 00:15:31
sql插入oracle链接的数据

报错OLE DB 访问接口 "OraOLEDB.Oracle" 返回了消息 "ORA-29275: 部分多字节字符"。

select addr from test_app
如果addr中有半个中文字符则会报这个异常,

insert into temp0812
select * from openquery([11],'select to_nchar(b.stdzdrugid),
to_nchar(b.sdid),
to_nchar(b.approvalnum),
to_nchar(b.drugname),
to_nchar(b.drugform),
to_nchar(b.drugspec),
to_nchar(b.drugfactor),
to_nchar(b.drugunit),
to_nchar(b.drugmaterial),
to_nchar(b.factoryname)
from temp0812 b
')