Answer / santhaebenezar

function will return a value where as
procedure may or maynot return a value

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
Table
Through Functions we can't

Answer / rambhupal reddy

function can use sql queries
procedure are not used in sql queries

Answer / parvathy

Procedure is written in natural language........
whereas function is a block of codes......

Answer / karthick.r

procedure may or may not return values but function should
return values

what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,

how to get the on hand quantity of an item across all organizations? name the underlying tables.

2 Answers   Ranves IT Solutions, Scan Steel,

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

12 Answers   TCS,

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,

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?

3 Answers   IBM,

where we find the status of order information.

2 Answers  

testing tools?

0 Answers   BirlaSoft, Convergys,

how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  

what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,

What are do's and dont's of Interface?

0 Answers