Re: pl/sql function

You could return a collection type (multiple rows) or a simple object type (multiple columns).

You might consider using a procedure with several OUT parameters if you didn't need to call it from SQL.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
 UK  Sept
 Australia August
 Malaysia September
 USA x 2  November

http://www.jlcomp.demon.co.uk/seminar.html

Peter wrote in message ...


>Is it possible to return two values when you write a function without

>concat? If yes, how do you do this?

>Thanks.

>

>