Oracle ADO.Net 异常
当我尝试执行以下 sql 块时，出现以下异常
ORA-06550: line 1, column 6:
PLS-00103: Encountered the symbol "" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
The symbol "" was ignored.
ORA-06550: line 2, column 47:
PLS-00103: Encountered the symbol "" when expecting one of t
查询：
begin
insert into test (a, b) values (:p1, :p2);
commit;
end;
注意：我添加了两个带有字符串值的参数 (p1, p2)
When I'm trying to execute the following sql block, I got the following Exception
ORA-06550: line 1, column 6:
PLS-00103: Encountered the symbol "" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
The symbol "" was ignored.
ORA-06550: line 2, column 47:
PLS-00103: Encountered the symbol "" when expecting one of t
The query:
begin
insert into test (a, b) values (:p1, :p2);
commit;
end;
Note: I added two parameters (p1, p2) with string values
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
删除尾随的;
Remove the trailing ;