at most one declaration for 'V_ZCSYCW1' is permitted Error: PLS-00371

sylmoon

于 2017-10-20 14:39:52 发布

阅读量2.6k

点赞数

本文链接：https://blog.csdn.net/sylmoon/article/details/78295214

版权

在PL/SQL编程中遇到了'PLS-00371'错误，提示'at most one declaration for 'V_ZCSYCW1' is permitted'。这个问题的根源在于变量重复定义。解决方案是检查并确保每个变量在整个代码块中只被声明一次，例如在遇到'v_TRAmodeType'变量重复定义的情况时，将其赋值为0即可消除该错误。

摘要由CSDN通过智能技术生成

Compilation errors for PROCEDURE AWCARGOWEBJMNEW.FML_SCHEDULE

Error: PLS-00371: at most one declaration for 'V_ZCSYCW1' is permitted
Line: 441
Text: (v_zcsycw1 / v_zczcw1) * 100 >= v_Firstspace AND

Error: PL/SQL: Statement ignored
Line: 440
Text: IF v_zczcw1 > 0 AND

Error: PLS-00371: at most one declaration for 'V_BZZCW1' is permitted
Line: 478
Text: IF v_bzzcw1 > 0 AND

Error: PL/SQL: Statement ignored
Line: 478
Text: IF v_bzzcw1 > 0 AND

Error: PLS-00371: at most one declaration for 'V_ZCSYCW1' is permitted
Line: 518
Text: (v_zcsycw1 / v_zczcw1) * 100 < v_Firstspace AND

Error: PL/SQL: Statement ignored
Line: 517
Text: IF v_zczcw1 > 0 AND

Error: PLS-00371: at most one declaration fo