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
Messages: 92
Registered: September 2008
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: 63941
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.

Re: Function vs. Procedure [message #400040 is a reply to message #399506] Sat, 25 April 2009 06:41 Go to previous message
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: Fri Oct 28 01:43:53 CDT 2016

Total time taken to generate the page: 0.09896 seconds