Home » Developer & Programmer » Forms » Function vs. Procedure (Oracle Forms 10g (Linux))
Function vs. Procedure [message #399506] Wed, 22 April 2009 11:12 Go to next message
dlwixon
Messages: 92
Registered: September 2008
Member
Is there a difference in speed between functions and procedures.

I need to either use a function returning a large varchar2 or usa procedure with an out parameter.

Is there a benefit either way?
Re: Function vs. Procedure [message #399507 is a reply to message #399506] Wed, 22 April 2009 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is the same unless you want to return the value in a SQL query.
See What is the difference between stored procedures and functions? in Wiki.

Regards
Michel
Re: Function vs. Procedure [message #400040 is a reply to message #399506] Sat, 25 April 2009 06:41 Go to previous message
alithegr8@gmail.com
Messages: 5
Registered: February 2009
Location: Saudi Arabia
Junior Member
A procedure performs an action, whereas a function returns a values.

Depending on the need, you can use function to return a value. If you simply wish to make changes or calculations on the items, then you should go for procedure.
Previous Topic: NVL2 not working
Next Topic: Creating text file from Forms 6i
Goto Forum:
  


Current Time: Wed Dec 07 03:18:24 CST 2016

Total time taken to generate the page: 0.09894 seconds