function [returning more than one value]

[Syed Zaheer Ulla]

Hello,
As we know function returns only one value, i had one doubt here that if we have out parameter in function can it return more than one.....
please let me know

[TRScheel]

Hello,
As we know function returns only one value, i had one doubt here that if we have out parameter in function can it return more than one.....
please let me know

What language are you using?

[bartonc]

Hello,
As we know function returns only one value, i had one doubt here that if we have out parameter in function can it return more than one.....
please let me know

Hi Syed. I've moved you post to Miscellaneous Questions. If you tell us the programming language that you are using, you'll be able to get answers from experts in that language.

From my understanding of C, for example, output parameters are a way to force "pass by reference". Which means that you can alter the value of a variable outside the function because a pointer is actually passed into the function instead of the value.

In Python, on the other hand, you can specify any number of variables on the return line and the interpreter packs them into a structure called a "tuple".

Hope that helps.

[debasisdas]

if you are using Oracle PL/SQL then you can do it.

[debasisdas]

If uare using oracle PL/SQL to write functions then that is possible

Using the RETURN clause, function can return only one variable. The variable can be of any data type - Number, VARCHAR, REF CURSOR, PL/SQL Table and many more. If the function is returning a data structure like PL/SQL Table, REF CURSOR etc, it is returning more than one value.

Another way of returning values is using OUT parameters. And this applies to both Procedures and Functions. Using OUT parameters, you can return as many values as you need.

If you have a need for OUT parameters, though, you would generally want a procedure, not a function. A function with OUT parameters cannot be called from a SQL statement, which rather defeats the purpose of using a function.


Function can able to return more than one value using ref cursur...

but that is not recomended.

[GeertVerhoeven]

Hi,

I don't know if it helps but here is a sample that returns a table. This way you can get multiple values (link ).

Greetz,

Geert

[kmm]

Hello,
As we know function returns only one value, i had one doubt here that if we have out parameter in function can it return more than one.....
please let me know

i think a function always return only a single value whtever the no. of parameters it may be

[TRScheel]

In .NET it is perfectly acceptable to return multiple parameters.

interface IInterface
{
    private bool MyFunction(out object Parameter1, out object Parameter2, out object Parameter3);
}
 

That function returns a bool, and has 3 parameters set to out.


Using c++ without .NET, you could set as many parameters as you want but they must be sent to the function by reference.