Answer / karthik

Print the results in .txt,.csv i.e,)notepad and excel

Answer / aswathy

This package is used in Oracle Forms to read and write to
an external file.

Answer / asif

This package is used to read text from files like .txt, csv,
plain text etc.

Answer / guest

Text_io package is used to print the result in excel sheet.

When will ON-VALIDATE-FIELD trigger executed ?

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 are the triggers associated with a check box?

2 Answers  

---

suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?

2 Answers   Oasis,

---

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

0 Answers  

---

What is the difference between object embedding & linking in Oracle forms?

1 Answers  

---

What is the difference between system.current_field and system.cursor_field ?

3 Answers  

---

what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)

1 Answers  

---

What are display items?

3 Answers  

---

I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent

0 Answers  

---

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

1 Answers  

---

When do you use data parameter type?

1 Answers  

---