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

最新推荐文章于 2024-03-13 17:34:57 发布

原创最新推荐文章于 2024-03-13 17:34:57 发布 · 2.8k 阅读

CC 4.0 BY-SA版权

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 for 'V_BZZCW1' is permitted
Line: 556
Text: IF v_bzzcw1 > 0 AND

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

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

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

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

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

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

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

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

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

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

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

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

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

Error: Hint: Value assigned to 'v_TRAmodeType' never used in 'FML_Schedule'
Line: 70

Text: v_TRAmodeType := 0;

SOLUTION :重复变量定义