PLS-00103:遇到符号“文件末尾".当期望以下之一时:; [英] PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ;

问题描述

我正在运行以下脚本-

BEGIN
    select department_name 
    from egpl_department 
    where department_id in (select department_id 
                            from egpl_casemgmt_activity);
END ;

出现错误-

PLS-00103: Encountered the symbol "end-of-file" when 
expecting one of the following: 
;

推荐答案

在PL/SQL块中，select语句应具有into子句:

In a PL/SQL block select statement should have an into clause:

DECLARE
 v_department egpl_department.department_name%type;
BEGIN 
  select department_name 
  into   v_department
  from   egpl_department 
  where  department_id in (select department_id from egpl_casemgmt_activity); 

  -- Do something useful with v_department
END; 

这篇关于PLS-00103:遇到符号“文件末尾".当期望以下之一时:;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！