Re: how to write a function that returns a dataset

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 18 Jul 2007 10:47:39 -0800
Message-ID: <469e523b$1@news.victoria.tc.ca>

RBTMEKRDQKDL_at_spammotel.com wrote:
: Hello,

: I'm quite new to oracle and probably there is no way to do what I want
: to do.

: I want to write a function that gets one input parameter and returns a
: dataset.

google: oracle CAST PIPELINED

	Your function can be made to look like a table and included 
	directly within SQL queries.

google: oracle ref cursor

Your code can loop over this, handling one row at a time.

'fraid you'll have to figure out the details for yourself, unless others post examples. Received on Wed Jul 18 2007 - 13:47:39 CDT