使用DbVisualizer执行Oracle语句片段报错PLS-00103:Encountered the symbol "end-of-file"

水深无声 2021-12-11 16:09 381阅读 0赞

今天使用DbVisualizer运行如下SQL片段

DECLARE
    	V_I INTEGER:=0;
    	V_ORGID VARCHAR2(32);
    BEGIN
    	FOR V_I IN 1..100 LOOP
    		SELECT ORGID INTO V_ORGID FROM 
    		(SELECT ORGID FROM ORG ORDER BY DBMS_RANDOM.VALUE())
    		WHERE ROWNUM=1;
    		DBMS_OUTPUT.PUT_LINE(V_ORGID);
    	END LOOP;
    END;

运行上述片段一直报如下错误

> 5:08:36 \[DECLARE - 0 row(s), 0.000 secs\] \[Error Code: 6550, SQL State: 65000\] ORA-06550: 第 2 行, 第 20 列:  
> PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:  
> \* & = - + ; < / > at in is mod remainder not rem  
> <an exponent (\*\*)> <> or != or ~= >= <= <> and or like like2  
> like4 likec between || multiset member submultiset  
> 15:08:36 \[V\_ORGID - 0 row(s), 0.000 secs\] \[Error Code: 900, SQL State: 42000\] ORA-00900: 无效 SQL 语句  
> 15:08:36 \[BEGIN - 0 row(s), 0.000 secs\] \[Error Code: 6550, SQL State: 65000\] ORA-06550: 第 3 行, 第 117 列:  
> PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:  
> 15:08:36 \[DBMS\_OUTPUT.PUT\_LINE(V\_ORGID) - 0 row(s), 0.000 secs\] \[Error Code: 900, SQL State: 42000\] ORA-00900: 无效 SQL 语句  
> 15:08:36 \[END - 0 row(s), 0.000 secs\] \[Error Code: 900, SQL State: 42000\] ORA-00900: 无效 SQL 语句  
> 15:08:36 \[END - 0 row(s), 0.000 secs\] \[Error Code: 900, SQL State: 42000\] ORA-00900: 无效 SQL 语句  
> … 6 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec \[0 successful, 0 warnings, 6 errors\]

看了无数遍，自己写的SQL片段没有任何问题，最后终于找到原因，在DbVisualizer使用BEGIN END片段时需要在前面**添加** **–/** DBVisaulizer就不会转义字符了，SQL片段运行成功

(添加了–/后，下面代码运行成功）

--/
    DECLARE
    	V_I INTEGER:=0;
    	V_ORGID VARCHAR2(32);
    BEGIN
    	FOR V_I IN 1..100 LOOP
    		SELECT ORGID INTO V_ORGID FROM 
    		(SELECT ORGID FROM ORG ORDER BY DBMS_RANDOM.VALUE())
    		WHERE ROWNUM=1;
    		DBMS_OUTPUT.PUT_LINE(V_ORGID);
    	END LOOP;
    END;