PL/SQL报错PLS-00103求助：遇到BEGIN符号不符合预期

错误信息 #

Error report -
ORA-06550: line 8, column 1:
PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following:

:= ( ; not null range default character
06550. 00000 - "line %s, column %s:
%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

原执行代码 #

DECLARE
c_id customers.ID%type :=1 ;
c_name customers.NAME%type ;
c_age customers.AGE%type ;
c_addr customers.ADDRESS%type ;
c_sal customers.SALARY%type 
BEGIN
SELECT NAME, AGE, ADDRESS, SALARY INTO  c_name, c_age, c_addr, c_sal FROM CUSTOMERS 
WHERE ID = c_id ;
dbms_output.put_line('Customer' || c_name || ' from ' || c_addr || 'earns' || c_sal ) ;
END ;
/

错误原因 #

DECLARE块中最后一个变量c_sal customers.SALARY%type末尾缺少分号，PL/SQL要求每个变量声明语句必须以分号结尾，语法不完整导致编译时识别BEGIN符号出现错误。

修正后的代码 #

DECLARE
c_id customers.ID%type :=1 ;
c_name customers.NAME%type ;
c_age customers.AGE%type ;
c_addr customers.ADDRESS%type ;
c_sal customers.SALARY%type ; -- 补上缺失的分号
BEGIN
SELECT NAME, AGE, ADDRESS, SALARY INTO  c_name, c_age, c_addr, c_sal FROM CUSTOMERS 
WHERE ID = c_id ;
-- 补充字符串拼接的空格，保证输出格式符合预期
dbms_output.put_line('Customer ' || c_name || ' from ' || c_addr || ' earns ' || c_sal ) ;
END ;
/

说明 #

修正后除了补上缺失的分号，还在dbms_output.put_line的字符串拼接中补充了空格，避免输出内容连在一起（原代码会输出CustomerRamesh from Ahmedabadearns2000，不符合期望的空格分隔格式）。

修正后的期望输出：

Customer Ramesh from Ahmedabad earns 2000  

内容的提问来源于stack exchange，提问作者subhransu pattnaik