Answer / guest

Record Group.

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

0 Answers  

---

What are the menu items that oracle forms 4.0 supports?

1 Answers  

---

What the PAUSE package procedure does ?

1 Answers  

---

What use of command line parameter cmd file?

1 Answers  

---

can i use lexical variable in formula column

1 Answers  

---

---

What is the use of hidden column?

1 Answers  

---

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

0 Answers  

---

what are the new features introduced in oracle form services in 11g release 2?

0 Answers  

---

When is PRE-QUERY trigger executed ?

3 Answers  

---

What is the difference between bind and lexical parameter?

0 Answers  

---

Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com

2 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  

---