anuragpuranik

 Profile Answers by anuragpuranik 

• Aug 12th, 2006

 

The function can not hav an out parameter Because function have a return statement.

Lalita.p

• Sep 17th, 2006

 

Function doesn't take Out Parameter.Store Procedure takes Out parameter.

Rani

• Dec 6th, 2006

 

Functions can accept parameters in three modes: IN, OUT, and IN OUT.

Technically, functions created with any of the three parameter modes will compile and runsuccessfully. Again, it is not a good programming practice to build functions with mode other than IN because functions always return a value.

BASAVARAJ KOLUR

• Mar 8th, 2007

 

function can take out parameter and in out parameter in that case it returns values
  to calling program with return value also
    accroding to me its not good programing style to use out and in out parameter for function
 if subprogram returns more than value you go for procedure,its returning one value you go for function

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

A cusor can tabke out parameter. But never use OUT and IN OUT parameters in functions. The main purpose of function is to take zero or more parameters and return a single value.