what is the difference between procedure and function
- 3 Answers
- 7556 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mry
procedure is for specific task and can return one or more
values to the caller
where as function is used for computing a value and it must
return a single value to the caller
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / tamil selvan.s
Main diff between procedure and function is
function can be used in select statement but
we cannot use procedure
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ramesh babu maldakal
1 Function returns the values but not procedure
2 We can call the functions in select statement but not
procedures
3 In procedures we can perform the DML operations but not
in Functions
| Is This Answer Correct ? | 2 Yes | 1 No |
How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?
What should be the batch size (number of customer records) general guidelines for optimal performance?
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
How to link modules in apps
what is difference between po_headers_all and po_headers
difference between 2 way and 4 way matching
how to initialize applications?
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
What are the validations you don in .CTL file in inbound interface process?
what is the difference between procedure and function
What is the interface?
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
Oracle Apps Technical 
