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.

any one can expalin report registration steps?

6 Answers   Infosys,

---

In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??

1 Answers  

---

How many phases of implementation and what are those.

2 Answers   Accenture,

---

What are the benefits of using soa architecture?

0 Answers  

---

HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?

2 Answers   TCS,

---

I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,

---

How many schemas we have? how many you have used?

0 Answers  

---

what is flexfield qualifier?

3 Answers  

---

define steps of assigning items to an organization.

1 Answers   Scan Steel,

---

What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,

---

Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  

---

wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,

---