Re: pl/sql function

"Peter" <depend3_at_yahoo.com> writes:

> Is it possible to return two values when you write a function without
> concat? If yes, how do you do this?
> Thanks.
>
>

As far as I know, you can only return one "thing" - however that "thing" could be a record which contains multiple other "things" - so if you need to return two (or more) distinct values, define a record which represents the values to be returned, put those values in the record and return that.

Alternatively, make one of the values you want to return an IN OUT parameter to the function call and put one value in that parameter and return the other.

Tim

--