今天使用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;