Oracle Functions

[Guest_imported]

Can Oracle functions return more than one parameter? If so what is the syntax? To return one parameter the syntax is:
Function name
(x number) return number is
y number;
body of function here
return y;
end name;


Please advise.

 

[carp]

Nope. Just one.

 

[jimbopalmer]

If you wish to use more than one out parameter, use a Procedure. I love everyone til they prove otherwise, sadly some prove otherwise SO quickly

 

[sem]

Use procedure with out parameters or function returning "composite" type (object, pl/sql table ...)