PLS-00313: 'XXXXX' not declared in this scope

最新推荐文章于 2024-04-26 23:37:15 发布

iteye_7017

最新推荐文章于 2024-04-26 23:37:15 发布

阅读量362

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle 文章标签：数据库

本文链接：https://blog.youkuaiyun.com/iteye_7017/article/details/82646920

oracle 专栏收录该内容

42 篇文章

订阅专栏

解释了在Oracle PL/SQL Package中如何正确放置私有Procedure/Function，以避免出现'PLS-00313: 'string' not declared in this scope'错误。提供了实例和解决办法。

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

Package中私有的Procedure/Function(没在Package Specification声明)需要注意放置的位置

比如下面的Package，Procedure A 想要调用 Procedure B，

CREATE OR REPLACE PACKAGE AAAAA AUTHID CURRENT_USER AS
  PROCEDURE A;
END AAAAA;

CREATE OR REPLACE PACKAGE BODY AAAAA AS
  PROCEDURE A IS
  BEGIN
    B;
  END;

  PROCEDURE B IS
  BEGIN
    dbms_output.put_line(\'In PROCEDURE B\');
  END ;

END AAAAA;

会报错：PLS-00313: \'B\' not declared in this scope

原因: B不是Public的Procedure，如果A想调用B，那么B的定义必须放在A的前边。

PLS-00313: "string" not declared in this scope
Cause: There is no declaration for the given identifier within the scope of reference. The identifier might be misspelled, its declaration might be faulty, or the declaration might be placed incorrectly in the block structure.
Action: Check the spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.

所以正确的写法是：

CREATE OR REPLACE PACKAGE BODY AAAAA AS
  PROCEDURE B IS
  BEGIN
    dbms_output.put_line(\'In PROCEDURE B\');
  END ;
 
  PROCEDURE A IS
  BEGIN
    B;
  END;
 
END AAAAA;

或者，如果确实想把B放到后边，那么可以在前面声明下，这样后边不过谁调用，也不会报错，这也是一个很好的习惯。

CREATE OR REPLACE PACKAGE BODY AAAAA AS
  PROCEDURE B;
 
  PROCEDURE A IS
  BEGIN
    B;
  END;

  PROCEDURE B IS
  BEGIN
    dbms_output.put_line(\'In PROCEDURE B\');
  END ;

END AAAAA;

Reference:http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:11471812249709