Re: Function w/o RETURN clause

Boobie wrote:
> Since when can PL/SQL Function without RETURN be compilable ?
> I could swear not in 8i....

Look up PIPELINED TABLE FUNCTIONS.

The following is a good example:

  CREATE OR REPLACE FUNCTION date_table(sdate DATE, edate DATE) RETURN date_array PIPELINED AS

BEGIN
   FOR i IN 0 .. (edate - sdate)
   LOOP
     PIPE ROW(sdate + i);
   END LOOP;
   RETURN;
END date_table;
/

More examples at www.psoug.org in Morgan's Library.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)