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 of data table can iterate in java or calling program.