Oracle equivalent of stored procedure that returns an inline table? -
example in t-sql (sql server - taken here ): create proc proc_authors @au_lname varchar(40) select au_id, au_fname, au_lname, city, state authors au_lname = @au_lname go is possible in oracle create stored procedure returns inline table (without declaring type - above)? if not, closest alternative? i.e. declare inline type, use it. idea minimize number of db permissions granted. please include sample code part of answer. reasoning behind using stored procedure vs function - have legacy software can execute stored procedures, or raw queries. appears stored procedures in there have support parameterized execution, after. try ref cursor procedure proc_get_tada(ip_user in varchar2, op_error_code out number, op_cursor out sys_refcursor,) begin open op_cursor select * your_table yt yt.user = ip_user; exception when others op_error_code := -1; end proc_get_tada; you collection o...