KD09714

 Profile Answers by KD09714 Questions by KD09714

• Jun 28th, 2008

 

Function must have return statement by which it returns one value.

Though we can use out parameter in function(function not getting called from select statement or DML), it is not good programming practice to write OUT and IN OUT in function. In case we wanted to return values using OUT parameters, always use procedures.

In case we wanted to return more than one value from function, use of ref cursor is preferred solution not OUT parameters.

Database Steve

 Profile Answers by Database Steve 

• May 20th, 2009

 

Functions always return a value.

Procedures do not.

The use of IN, OUT, and IN_OUT parameters as scalar values or ref cursors is dependent on your need and overall performance not on a pseudo-standard as answered above.