Answer / guest

& physical page no.

Answer / sudipta santra

This is the way how to display the page number.

SRW.GET_PAGE_NUM (page_num);

Description: This Function returns the current page number.
This is useful when you want to use the page number in the
field's Format Trigger property.
Syntax:
SRW.GET_PAGE_NUM (page_num);
Parameters:
page_num: Is the variable in which you want to place the
current page number.
Returns: The current page number variable into the boiler
plate text item in the report.

What are the design facilities available in forms 4.0?

1 Answers  

---

What are the types of canvas-views?

1 Answers  

---

State the order in which these triggers are executed ?

1 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  

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---

What built-in is used for showing the alert during run-time?

1 Answers  

---

What are the triggers associated with a check box?

2 Answers  

---

What is a radio Group?

1 Answers  

---

how report can be generated if we have the database designed in oracle 10g?

0 Answers  

---

What is the use of place holder column?

1 Answers  

---

Which is the cheapest and quality Oracle Education provider in Bangladesh?

1 Answers  

---

What are the ways to monitor the performance of the report?

1 Answers  

---