ORA-00604: 问题处理

最新推荐文章于 2024-05-18 11:35:06 发布

zw0558

最新推荐文章于 2024-05-18 11:35:06 发布

阅读量875

点赞数 1

分类专栏：数据库

本文链接：https://blog.csdn.net/zw0558/article/details/43758831

版权

数据库专栏收录该内容

8 篇文章 0 订阅

订阅专栏

PACKAGE BODY M8CONNECT.PACKXINEM8AMDIC 编译错误

错误：PL/SQL: ORA-04052: error occurred when looking up remote object NASSET.建卡任务数据表@DICDATALINK
ORA-00604: error occurred at recursive SQL level 1
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from DICDATALINK
行：22
文本：cursor curAddress is SELECT DISTINCT asset.所在地点 VARDESC FROM NASSET.建卡任务数据表@DICDATALINK ASSET WHERE (NOT EXISTS (SELECT UQATTRID FROM TAM_ADDRESS ADDRESS WHERE (ADDRESS.VARDESCRIPTION=asset.所在地点) AND (ADDRESS.UQUNITID=VUNIT))) AND (asset.所在地点 IS NOT NULL) AND (asset.建卡任务ID=vTASK);

错误：PL/SQL: SQL Statement ignored
行：22
文本：cursor curAddress is SELECT DISTINCT asset.所在地点 VARDESC FROM NASSET.建卡任务数据表@DICDATALINK ASSET WHERE (NOT EXISTS (SELECT UQATTRID FROM TAM_ADDRESS ADDRESS WHERE (ADDRESS.VARDESCRIPTION=asset.所在地点) AND (ADDRESS.UQUNITID=VUNIT))) AND (asset.所在地点 IS NOT NULL) AND (asset.建卡任务ID=vTASK);

错误：PL/SQL: ORA-04052: error occurred when looking up remote object NASSET.建卡任务数据表@DICDATALINK
ORA-00604: error occurred at recursive SQL level 1
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from DICDATALINK
行：134

文本：CURSOR CURIMPORT IS SELECT A.ROWID VARNUM, A.建卡任务id, A.待建卡资产序号, A.工程项目编号, A.该工程预转固批号, A.预转固资产序号,

解决方法：在网上搜集好多资料，没有解决问题，还有一种说法是oracle的补丁没有升级，由于升级会影响太大，所以也没有尝试。

最终解决方法：重新创建DBlink访问的表。而且没有创建索引。因为只要创建索引就报同样的错误。