procedure proc( arg1 in varchar(32), arg2 in number, result out sys_cursor ) as begin open result for select col1, col2, 'FOO' col3 from tableFoo where col7=arg1 or col8=arg2 ; end;