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块语法还是要严谨一点,要告诉它什么时候结束;