Answer / guest

fun returns values
proc may or may not return values

fun always contain a return statement
proc not.

fun can be used in select queries
proc can not be.

Answer / honnaiah

Function computes results.
Procedure performes an action

Answer / venkat

Function has to return a value where as a procedure may or may not return a value

List system variables available in forms 4.0, and not available in forms ?

1 Answers  

---

There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?

3 Answers   3i Infotech,

---

How can you format a character field in a report Layout editor ?

1 Answers   Convergys,

---

What is WHEN-Database-record trigger?

1 Answers  

---

What is a Layout Editor?

2 Answers  

---

What Enter package procedure does ?

1 Answers  

---

What is a library?

1 Answers  

---

What are the types of calculated columns available?

1 Answers  

---

What is the use of Page Protect Property?

1 Answers   GE,

---

What is the main difference between Reports 2.0 & Reports 2.5?

1 Answers  

---

Where is a procedure return in an external pl/sql library executed at the client or at the server?

1 Answers  

---

Is it possible to attach same library to more than one form?

1 Answers  

---