create or replace function F_DELETE_USER ( parWStr in VARCHAR ) return varchar2 is str varchar2(50); begin -- delete user and user group relation str:='delete from sys_user05 where '||parWStr; execute immediate str; -- delete user str:='delete from sys_user02 where '||parWStr; execute immediate str; return '02'; exception when others then rollback; return '01' ; end F_DELETE_USER;
end;
--- 这一行也去掉
语法错误也有,例如没有使用动态SQL. 同意楼上的,先看看帮助吧.
(
parWStr in VARCHAR
)
return varchar2
is
str varchar2(50);
begin
-- delete user and user group relation
str:='delete from sys_user05 where '||parWStr;
execute immediate str;
-- delete user
str:='delete from sys_user02 where '||parWStr;
execute immediate str;
return '02'; exception
when others then
rollback;
return '01' ;
end F_DELETE_USER;