ORA-00604: 问题处理
来源:互联网 发布:淘宝的主营业务有哪些 编辑:程序博客网 时间:2024/06/05 20:40
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
错误: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访问的表。 而且没有创建索引。 因为只要创建索引就报同样的错误。
0 0
- ORA-00604: 问题处理
- 某天的ORA-00604问题处理
- ORA-16038 问题处理
- ORA-16038 问题处理
- ORA-16038 问题处理
- ORA-16038 问题处理
- ORA-16038 问题处理
- ORA-00018 问题处理
- ORA-00600 [3020] ORA-10560问题处理
- ORA 01589问题处理记录
- ora-600 kclcls_8问题处理
- 用户无法顺利删除问题处理一则-ORA-00604和ORA-00942错误
- oracle drop用户cascade 无法顺利删除问题处理-ORA-00604和ORA-00942错误
- ORA-39006,ORA-39213,ORA-06512,ORA-01114,ORA-39065,ORA-39097,ORA-01403 EXPDP报错问题处理
- ORA-01113和ORA-01113的问题处理
- ORA-20011 ORA-29913 KUP-11024问题处理
- ora-04031 share pool问题处理
- 密码过期 ora-28002 问题处理
- 幸福
- URAL 1515 Cashmaster 数学题
- Hack3--Creating a custom ViewGroup
- combo实现年、月展示
- 结合美团下单率预测详解机器学习中的数据清洗与特征处理
- ORA-00604: 问题处理
- Android4.4 wpa_supplicant深入分析之wpa_supplicant初始化流程续
- CSS float浮动的深入研究、详解及拓展(一)
- 阿里巴巴集团web安全标准Ver1.4
- Linux驱动程序安装步骤(包括PC上及开发板上)
- openssl aes 高级加解密
- 丰乳细臀——读《丰乳肥臀》
- GetCurrentDirectory,SetCurrentDirectory使用例子
- Build Variants 1 (release and debug) (Android Studio 使用)