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 is a value set? List its various types.

0 Answers  

---

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

0 Answers   IBM,

---

I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,

---

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

---

---

Can We Create a Synonym On Trigger?

7 Answers   Exeter, Oracle,

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,

---

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

---

how can we get odd numbered pages in output of a report

2 Answers   Infosys,

---

What is FORWARD DECLARATION in Packages?

6 Answers   British Telecom BT, HCL, Tech Mahindra,

---

Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers   Wipro,

---