Home » SQL & PL/SQL » SQL & PL/SQL » Function & Procedure
Function & Procedure [message #241446] Tue, 29 May 2007 11:18 Go to next message
t.guru
Messages: 5
Registered: May 2007
Junior Member
Hi all

pls tell me diff b/w Function & Procedure & will excute
faster.
Re: Function & Procedure [message #241448 is a reply to message #241446] Tue, 29 May 2007 11:22 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Please Read The Fine Concepts Manual found at http://tahiti.oracle.com
Re: Function & Procedure [message #241455 is a reply to message #241446] Tue, 29 May 2007 12:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No difference but function returns a value.

Regards
Michel
Re: Function & Procedure [message #241485 is a reply to message #241455] Tue, 29 May 2007 15:16 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Not No difference. A function can be called from a sql statement (under the appropriate conditions) a proc cannot. A function MUST contain at least one return clause. Based on the other stuff that you have written Michel, I have a feeling that you have a different meaning behind your statement.
Re: Function & Procedure [message #241486 is a reply to message #241485] Tue, 29 May 2007 15:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, this was what I meant although I thought only in PL/SQL terms and forgot the call from SQL.
Thanks for adding it.

Regards
Michel
Re: Function & Procedure [message #241491 is a reply to message #241486] Tue, 29 May 2007 15:28 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
No Probs Michel. Glad to contribute
Previous Topic: Procedure to map 2 tables data
Next Topic: dbms_sql and save exception
Goto Forum:
  


Current Time: Tue Dec 06 04:45:59 CST 2016

Total time taken to generate the page: 0.10181 seconds