Answer / mry

procedure is for specific task and can return one or more
values to the caller
where as function is used for computing a value and it must
return a single value to the caller

Answer / tamil selvan.s

Main diff between procedure and function is
function can be used in select statement but
we cannot use procedure

Answer / ramesh babu maldakal

1 Function returns the values but not procedure
2 We can call the functions in select statement but not
procedures
3 In procedures we can perform the DML operations but not
in Functions

what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,

---

What is multoorg and what is it's level or structure

4 Answers   IBM,

---

How to make Parameter as Mandatory?

2 Answers  

---

define steps of assigning items to an organization.

1 Answers   Scan Steel,

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

sourcing in GL

1 Answers   Convergys,

---

in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?

1 Answers   Oracle,

---

what is difference between d2k report and oracle apps report

10 Answers   Seven Hills, Wipro,

---

maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,

---

for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  

---

What is the difference between buyer&employee in PO module?

7 Answers   TCS,

---

please send me forms, xml pulisher questions,answers

0 Answers   Zensar,

---