what is difference between procedure and function
Answers were Sorted based on User's Feedback
Answer / santhaebenezar
function will return a value where as
procedure may or maynot return a value
|Is This Answer Correct ?||6 Yes||1 No|
Answer / venky
Function can be use in SQL queries
Procedure can't be used in SQL queries
Function call by an Expression
Procedure call by Statement
The Main diff is DML
Through procedures we can insert,update,delete data from
Through Functions we can't
|Is This Answer Correct ?||5 Yes||4 No|
Answer / rambhupal reddy
function can use sql queries
procedure are not used in sql queries
|Is This Answer Correct ?||1 Yes||0 No|
Answer / parvathy
Procedure is written in natural language........
whereas function is a block of codes......
|Is This Answer Correct ?||1 Yes||2 No|
Answer / karthick.r
procedure may or may not return values but function should
|Is This Answer Correct ?||0 Yes||1 No|
Difference between Bind and Lexical parameters?
How can a process be deployed in soa?
What is request group
IN WHICH MODULE THE LEGAL ENTITY COMES?
What are do's and dont's of Interface?
what is difference between d2k report and oracle apps report
What are the requests groups?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter
Are you familiar with internet architecture of oracle apps 11i?
wheather discard file is automatically created or explicty created?can u mention it?
what are the different transaction clauses in AR?