创建和执行存储过程如下
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);哪里出错了? 各位一般怎么调试?调试时怎么看更详细的提示信息?
(
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;
---------这样没错
----------这个搞什么的,去掉
begin
Pro_Insert_TEMTBL(1,2);
end;调用的时候要用begin end; 括起来。
真是奇怪。