写了一个procedure,编译通过,却不能测试。一点测试就出现如下错误:
ORA-06563: top level procedure /function specified, cannot have subparts我就纳闷了,以前没碰到过啊,于是我就试了一个最简单的
create or replace procedure ttttt is
begin
delete from zyj1 where id=10;
end ttttt;
点测试,错误依旧这到底是什么问题啊???
ORA-06563: top level procedure /function specified, cannot have subparts我就纳闷了,以前没碰到过啊,于是我就试了一个最简单的
create or replace procedure ttttt is
begin
delete from zyj1 where id=10;
end ttttt;
点测试,错误依旧这到底是什么问题啊???
begin
execute immediate 'delete from zyj1 where id=10';
end ttttt;
同时用PL/SQL DEV进行逐行调试,看看执行存储过程了?
还是 ORA-06563: top level procedure /function specified, cannot have subparts
没经验啊...居然有一个procedure跟用户同名,导致所有的procedure都不能用了..