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

a text item is there what r the different types of triggers associated with it

0 Answers  

---

What is the use of transactional triggers?

1 Answers  

---

What is the advantage of the library?

2 Answers  

---

What are the difference between lov & list item?

1 Answers   ESS,

---

What is a record group?

1 Answers  

---

---

explain about content canvas views?

1 Answers  

---

Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 Answers  

---

what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)

1 Answers   IBM, Oracle,

---

What are the vbx controls?

1 Answers  

---

Can a formula column be obtained through a select statement?

1 Answers   TCS,

---

can i write commit in Before report trigger

4 Answers  

---

i created a parameter list in reports. how to restrict that parameter list with parameters

1 Answers   iFlex,

---