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?

Report message to a moderator

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: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: NVL2 not working
Next Topic: Creating text file from Forms 6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 23:03:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.