开发者

Oracle exception with ADO.Net

开发者 https://www.devze.com 2023-01-20 03:17 出处:网络
When I\'m trying to execute the following sql block, I got the following Exception ORA-06550: line 1, column 6:

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 expecti开发者_开发技巧ng 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


Remove the trailing ;

0

精彩评论

暂无评论...
验证码 换一张
取 消