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

今天使用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;
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

风水月

从心底相信自己是成功的第一步

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值