oracle - OUT/IN OUT parameters in PL/SQL function -

oracle - OUT/IN OUT parameters in PL/SQL function -

as far understood it, possible have out or in out parameters procedures, not functions. however, when defining user-defined aggregate function, have found signature:

member function odciaggregateiterate(self in out deviationimpl, value in number) homecoming number

this seems function, however, has in out parameter. explain me why possible?

thanks

there no such restrictions. functions can have out or in out parameters.

however, oracle recommends against using them.

out , in out parameters prevent function beingness used plain sql, marked deterministic function or used result-cached function. these type of parameters problem if want utilize function in sql query.

your illustration more specific: it's fellow member function, not global function.

sql oracle function stored-procedures plsql