ora-04052: ora-00604:ora-03106: dblink放在存储过程里执行报错

不知道什么原因,网上有说法是,远程数据库与本地数据库版本不同引起的BUG。创建的同义词正常,在存储过程则编译不过。
然后把 同义词 drop 改为建为视同,就编译通过了。
错误提示:

Error: PL/SQL: ORA-04052: error occurred when looking up remote object [email protected]_SGSBJHK
ORA-00604: error occurred at recursive SQL level 1
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from TO_SGSBJHK
Line: 99
Text: INSERT INTO SNZY_IC89_UPLOAD

解决办法:

1
create view SNZY_IC89_UPLOAD as select * from [email protected]_SGSBJHK;

编译过程通过。