Function and Procedure

code_lover · March 9th, 2007, 05:10 PM

What are procedures and functions in Oracle and how to convert a function into a procedure and vice versa.
Please provide examples.

MAXOOD!

Life is an endless journey towards perfection

peace95 · March 26th, 2007, 01:23 AM

code_lover:
Procedures are named and stored that may or may not return a value. However, they must return the success or failure at execution time.

Functions are similar to procedures in structure, but they MUST return a single value by using the RETURN-value clause. Functions are also named and can be called from a procedure.

Hope this helps.

========================
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

GeertVerhoeven · July 24th, 2007, 07:05 AM

NOTE: Functions can also return tables like in this sample: http://geertverhoeven.blogspot.com/2...rns-table.html

The main different is the way how to use them.

A function can be used within a query where a procedure can't.

Greetz,

Geert

http://geertverhoeven.blogspot.com