PLS-00108: declarative units must be a single variable declaration

PLS-00108: declarative units must be a single variable declaration
Cause: While checking a declarative unit (a top-level declare block without the BEGIN...END), PL/SQL found that there was more than one item declared or that the item was not a variable declaration. A table is a common variable declaration at the unit level. To define a TABLE, compile a DECLARE compilation unit, but only one at a time is allowed.
Action: Declare variables in separate declarative units.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:01

PLS-00108：声明单位必须是单个变量声明,
.原因：在检查声明单元（没有BEGIN ... END的顶级声明块）时，PL / SQL发现声明了多个项目，或者该项目不是变量声明。表是单位级别的常用变量声明。要定义一个TABLE，编译一个DECLARE编译单元，但一次只允许一个。,
.操作：以单独的声明单位声明变量。,
.

aiaiDBA

13718043309

010-86462881

PLS-00108: declarative units must be a single variable declaration

1 个回答

相似问题