17,078
社区成员
发帖
与我相关
我的任务
分享
create or replace function funtmp3 return varchar
is
cur sys_refcursor;
cur2 sys_refcursor;
begin
cur := funtemp();
cur2:= funtmp2(cur);
return '';
end funtmp3;
-- 函数1
create or replace function funTemp return SYS_REFCURSOR
IS
v_rc SYS_REFCURSOR;
begin
open v_rc for select * from t_test;
return (v_rc);
end funTemp;
-- 函数2,入参数函数1的返回类型
create or replace function funtmp2(cur SYS_REFCURSOR) return SYS_REFCURSOR
is
begin
return cur;
end funtmp2;
select * from
(
select n.id from node n where n.swimlane_id in(select t.id from swimlane t where t.schema_id='vProcessId')
) as T
where t......