Re: pl/sql function

"Peter" <depend3_at_yahoo.com> wrote in message news:bjy_8.20770$8o4.2513_at_afrodite.telenet-ops.be...
> Is it possible to return two values when you write a function without
> concat? If yes, how do you do this?
> Thanks.
>
>

By design a function can only return one single value. That's why it is a function, otherwise you would need to use a procedure. Functions can return values using composite types, provided the type has been defined before. This is all outlined in the pl/sql reference manuals.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address