Store procedure question...

[BbEsy]

im working with ms sql for few years, now i changed it to oracle..

how i can make stored procedure returns a table ?

in msssql is ..
CREATE PROCEDURE dbo.GetRecord (@ID int)
AS
select ID,Name, Value2 from tblMain Inner join tblData on tblData.fkMain = tblMain.pkMain where id=@ID

how i can write it in oracle sql ?

[rski]

Define a pipelined function

http://www.akadia.com/services/ora_pipe_functions.html

[debasisdas]

I think a procedure / function with ref cursor as out parameter is what you are looking for.