I think a function can have out parameter; though its rare. The only restriction is that it cannot be called from a stand-alone sql statement; but can be called from a plsql block.
Above answer was rated as good by the following members: seenu333p
I think a function can have out parameter; though its rare. The only restriction is that it cannot be called from a stand-alone sql statement; but can be called from a plsql block.
RE: Can a function take OUT parameters. If not why?
yes fuction can take out variable but the good programing practice is to not use the out parameter since function must return only one value to the calling envoirnment.
RE: Can a function take OUT parameters. If not why?
yes functions can have out parmaters
Function:-
create or replace function fun_hello(p_mystring in varchar2 p_outstring out varchar2) return varchar2 is begin P_outstring: p_mystring; return 'hello'; end fun_hello;
1 
0