Passing a Function name in Parameter

Can we pass a function name as a parameter value?? will it have any effect in performance degradation when used in a Large online transaction process?

Questions by srividhya_85   answers by srividhya_85

Showing Answers 1 - 2 of 2 Answers

murugesan

  • Jan 19th, 2013
 

Yes we can pass but the function should return a value of type appropriate for the calling function

Example

round(trunc(100))

tinku981

  • Jun 14th, 2013
 

About performance, it depends upon the computations you will be performing inside that function. Also, if we are using (user-defined) function in SQL (rather than creating PL/SQL), then it will give better performance.

While using user-defined functions, we need to avoid Mutating functions error.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions