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 the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

25 Answers   IBM, Satyam,

---

PL/SQL stored procedure parameters?

7 Answers  

---

How is choreography different from orchestration?

0 Answers  

---

what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

---

What is SRW Package? (Sql Report Writer)

1 Answers  

---

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

---

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,

---

IN WHICH MODULE THE LEGAL ENTITY COMES?

5 Answers  

---

How will u register concurrent request ?

1 Answers   Convergys,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen

2 Answers   TCS,

---