what is the difference between procedure and function

Answer Posted / srinivas

Function returns only one value, whereas procedure returns
multiple values.
Function can be used in SQL queries whereas we can't use
procedures.
I think in procedures values by reference is not possible.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do you describe O2C along with tables

2506


How to create a purchase order without a requisition?

848


How can you achieve loose coupling in soa framework?

981


In support project one ticket alloted which steps follows manualy tell me ?

2418


List the types of flexfield?

784


Tell me how to find the custom directory in front end?

853


What is count(*) from po_vendors(any table)?

822


where to define interorganization transaction charges and what are the different options?

2152


Can u give the Documentation of Custom.pll in oracle apps

3222


How to move the one file from one instance to another instance? And your scripts also?

822


What is sca and how is it useful?

840


Can you differentiate between mediator and osb?

855


what are the different transaction clauses in AR?

1828


What is a value set? List its various types.

849


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1966