create or replace function "DelBook"(id varchar(20)) return boolean is isdel boolean; begin delete from Books where bid=id; if SQL%NOTFOUND then isdel:=false; else isdel:=true; end if; return (isdel); end DelBook;比如这个函数,他也说“创建函数带有编译错误”但又不指出哪错
更正一下 create or replace function DelBook(id varchar) return boolean is isdel boolean; begin delete from Books where bid=id; if SQL%NOTFOUND then isdel:=false; else isdel:=true; end if; return (isdel); end DelBook;
另外装一个pl/sql developer真是一个不错的主意。
用TOAD也行啊。
在那里面编译,你可以看到错在哪儿了。
create or replace function "DelBook"(id varchar(20)) return boolean is
isdel boolean;
begin
delete from Books where bid=id;
if SQL%NOTFOUND then
isdel:=false;
else
isdel:=true;
end if;
return (isdel);
end DelBook;比如这个函数,他也说“创建函数带有编译错误”但又不指出哪错
create or replace function DelBook(id varchar) return boolean is
isdel boolean;
begin
delete from Books where bid=id;
if SQL%NOTFOUND then
isdel:=false;
else
isdel:=true;
end if;
return (isdel);
end DelBook;