hellow man
u cant create a function that have morethan one out variable
a function is that it gets any number of inputs and returns only one value
A procedure can help u to satisfy ur needs .A procedure can have any number of in (input) variables and any number of out(return variable)variab les.
A procedure can have variables that acts as both in and out variables

[code=oracle]

create or replace...