what is the difference between procedure and function
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / venki_discussions
procedure perform one or more actions it may return or may
not return values if u want to return procedure ill return
multiple values.we can use procedures in oracel apps also
function perform one or more actions and it must return any
value multiple values will not return function.functions
we cant use in oracle apps.we can perform functions on SQL
prompt itslef.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / chalam
Function will return only 1 value where as the procedures
will return values or may not be return.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / allabakash
function and procedure both are stored procedures
function contains return clause,where as procedure does not contain return clause
function must return a value, where as procedure may or may not return a value
function can execute as a select statement, where as procedure can execute in anonymous block
we can call function in if statement, we cannot call procedure in if statement
we can call function as a part of expression,where as procedure as a statement
we can pass function as a parameter,where as we cannot pass procedure as a parameter.
Is This Answer Correct ? | 0 Yes | 0 No |
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
what are the types of interfacing?
suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?
Can we run a package with out specification?If yes how?
Is that Possible To create package without Specification , If Yes Give any Examples
WHAT IS USE OF APPS API?
diff between key and descriptive flexfield.
What are triggers?
How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?
name all status attributes.
What is secuirity's in R12 features.