执行PL/SQL块时出现 ORA-06550 错误（批量建表）

来源：互联网发布：mysql schema是什么编辑：程序博客网时间：2024/06/05 15:38

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

直接上图

报出的错误，感觉有点迷惑，就查看了一下官方文档

官方解释

ORA-06550: line string, column string: string

Cause: Usually a PL/SQL compilation error.

Action: None

网络查找解决方案

ORA-06550 line string, column string:string
Cause: A PL/SQL compilation error has occurred. The numbers given for line and column are the location in the PL/SQL block where the error occurred.
Action: Refer to the following PL/SQL messages for more information about the error.

最终还是要看报错信息，提示是第7行0列出现了问题，又有关于；号的提示，难道end后需要加；号，于是就加上去；

OK，执行成功；

看来执行PL/SQL块语法还是要严谨一点，要告诉它什么时候结束；