执行存储过程出现ORA-00900:invalid SQL statement
创建和执行存储过程如下
CREATE OR REPLACE PROCEDURE Pro_Insert_TEMTBL
(
v_AA in varchar2,
v_BB in varchar2)
is
begin
insert into Temtbl(AA,BB)values(v_AA,v_BB);
commit;
end Pro_Insert_TEMTBL;
Pro_Insert_TEMTBL(1,2);
哪里出错了? 各位一般怎么调试?调试时怎么看更详细的提示信息?
------解决方案--------------------
CREATE OR REPLACE PROCEDURE Pro_Insert_TEMTBL
(
v_AA in varchar2,
v_BB in varchar2)
is
begin
insert into Temtbl(AA,BB)values(v_AA,v_BB);
commit;
end Pro_Insert_TEMTBL;
---------这样没错。。。
------解决方案--------------------
Pro_Insert_TEMTBL(1,2);
----------这个搞什么的,去掉