proc1 (id number, flag number default 0, result out sys_refcursor );
create view view1 as -- типа такого select * from table (proc1(1,1,res));