不知道怎么会是我在单步测试sql语句时都能通过,但是调入过程中后就老是提示错误,过程为
create procedure test
as
begin
update dept set dname='dog' where deptno=40;
/
end;
end test;
还有就是在存储过程中用select语句也会出现问题,请高手帮忙啊,先在这里谢过了
create procedure test
as
begin
update dept set dname='dog' where deptno=40;
/
end;
end test;
还有就是在存储过程中用select语句也会出现问题,请高手帮忙啊,先在这里谢过了
begin
update dept set dname='dog' where deptno=40; end test;
/相当于commit;
况且我已经去掉了,还是不行提示:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
begin case declare
end exception 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
<a single-quoted SQL string> pipe
as
begin
update dept set dname='dog' where deptno=40;
end;
在过程中用select的时候一定要把结果赋值到一个变量去中才行,如:
定义变量 v_count number;
select count(1) into v_count from dept;
CREATE OR REPLACE PROCEDURE TEST AS
BEGIN
UPDATE DEPT SET DNAME = 'DOG' WHERE DEPTNO = 40;
COMMIT;
END;