楼主可以检查一下 Select curr.userid from tbl_ework_flow_curroper curr where curr.insid=insid and curr.userid=userid; 的查询结果是什么样子的!
一般都用select count(*) from ..... 的结果来判断是否存在create or replace function isoper(insid varchar2,userid varchar2) return varchar2 as id number; isCreator VARCHAR2(10);begin id:=0; Select count(*) into id from tbl_ework_flow_curroper curr where curr.insid=insid and curr.userid=userid; if id>0 then isCreator :='true'; else isCreator :='false'; end if;return isCreator; end isoper;
Select curr.userid from tbl_ework_flow_curroper curr where curr.insid=insid and curr.userid=userid;
的查询结果是什么样子的!
的结果来判断是否存在create or replace function isoper(insid varchar2,userid varchar2) return varchar2
as
id number;
isCreator VARCHAR2(10);begin
id:=0;
Select count(*) into id from tbl_ework_flow_curroper curr where curr.insid=insid and curr.userid=userid;
if id>0 then
isCreator :='true';
else
isCreator :='false';
end if;return isCreator;
end isoper;