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.

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.

Answer / chalam

Function will return only 1 value where as the procedures
will return values or may not be return.

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.

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

---

what is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,

---

In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,

---

how to print multi lay outs,muti currency,muti language in xml publisher

2 Answers   Deloitte, Oracle,

---

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

---

In one flat file i got headers and lines data how you can write control file now ?

1 Answers   KPMG,

---

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  

---

what is the error you will get if field is referenced in wrong repeating frame?

1 Answers  

---

what is difference between po_headers_all and po_headers

2 Answers   NTT Data,

---

How to develop XML report without rdf?

4 Answers   Oracle,

---

Tell me where we find the status of order information?

0 Answers  

---

Plz anybody send me Technical specification for AP Interface

0 Answers   Satyam,

---