retrive morethan one value

[krishhhna]

how we can retrive more than one value by using function? could you please give me the example

[Mala232]

how we can retrive more than one value by using function? could you please give me the example

Hello,
use IN ,OUT ,INOUT modes while using parameters to a function
regards,
mala

[Rakeshy]

Hello,
use IN ,OUT ,INOUT modes while using parameters to a function
regards,
mala

Hi,
You can use Ref Cursor.

Bye

[debasisdas]

You need to use Function with OUT parameters.

[Saii]

It is better to use procedure when you want to send multiple values. Functions should be limited to return one value.