Error:Oracle transparent gateway connect to SQL Server error

[mwgxq]

Error:insert data into SQL Server using database link(Oracle transparent gateway):
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]
ORA-02063: preceding 2 lines from RISK
But select and desc using the link is OK? Why?

[davey23uk]

because you did something wrong and provide no details of what you have actually done.

[mwgxq]

透明网关配置成功，创建的数据库连接为：riskh2000
SQL> select entry_id from ERR_LOG@riskh2000;

ENTRY_ID
------------------
232520051255122172
232520051255122172
232520051255122653
232520051255122653
233520050355566608
233520050355566608
233520051355141143
233520051355141143

已选择8行。

SQL>
SQL> insert into ERR_LOG@riskh2000("ENTRY_ID","CREATE_DATE","SOURCE","DESCRIPTIO
N")
2 values('230220051025016269',to_date('2005-11-14 23:58:44','yyyy-mm-dd hh24
-mi-ss'),
3 'OraOLEDBmodVBMiddle:PowerDoQuery[on RNJAPPS1]modVBMiddle:RunSPReturnMulti
RS_RW[on RNJAPPS1]MFT_ProcDeclRel.ChkMftRead:GetMftData[on RNJAPPS1]MFT_ProcDecl
Rel.ChkMftReadeclChk_Muti[on RNJAPPS1]MFT_ProcDeclRel.ChkMftReadeclMftRead[o
n RNJAPPS1]DeskCheck:ManifestCheck[on RNJAPPS1]DeskCheck:CheckPeriphery[on RNJAP
PS1]DeskCheck:EntryDeskCheck/周边o',
4 'ORA-00933: SQL command not properly endedORA-06512: at "ALLSYS.MFT_PKG",
line 268ORA-06512: at line 1');

已创建 1 行。

SQL> commit;

提交完成。

SQL> delete from ERR_LOG@riskh2000 where entry_id='230220051025016269';

已删除 1 行。

SQL> commit;

提交完成。

SQL> insert into ERR_LOG@riskh2000("ENTRY_ID","CREATE_DATE","SOURCE","DESCRIPTIO
N")
2 values('230220051025016269',to_date('2005-11-14 23:58:44','yyyy-mm-dd hh24
-mi-ss'),
3 'OraOLEDBmodVBMiddle:PowerDoQuery[on RNJAPPS1]modVBMiddle:RunSPReturnMulti
RS_RW[on RNJAPPS1]MFT_ProcDeclRel.ChkMftRead:GetMftData[on RNJAPPS1]MFT_ProcDecl
Rel.ChkMftReadeclChk_Muti[on RNJAPPS1]MFT_ProcDeclRel.ChkMftReadeclMftRead[o
n RNJAPPS1]DeskCheck:ManifestCheck[on RNJAPPS1]DeskCheck:CheckPeriphery[on RNJAP
PS1]DeskCheck:EntryDeskCheck/周边op',
4 'ORA-00933: SQL command not properly endedORA-06512: at "ALLSYS.MFT_PKG",
line 268ORA-06512: at line 1');
insert into ERR_LOG@riskh2000("ENTRY_ID","CREATE_DATE","SOURCE","DESCRIPTION")
*
第 1 行出现错误:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]
ORA-02063: preceding 2 lines from RISKH2000


SQL>
the source: varchar(4000). Why?