Answer Posted / fatima hussain

DECLARE
PL_ID PARAMLIST;
PL_NAME VARCHAR2(100) := 'PL_ACCCODE';
BEGIN

PL_ID := GET_PARAMETER_LIST(PL_NAME);
IF NOT ID_NULL(PL_ID) THEN
DESTROY_PARAMETER_LIST(PL_ID);
END IF;

PL_ID := CREATE_PARAMETER_LIST(PL_NAME);

(Add more parameter according to your need and also use the
additional line of code according to to your need)

ADD_PARAMETER(PL_ID, 'P_DATE1',
TEXT_PARAMETER, :CON_BLK.DATE1);
ADD_PARAMETER(PL_ID, 'P_DATE2',
TEXT_PARAMETER, :CON_BLK.DATE2);

ADD_PARAMETER(PL_ID, 'PARAMFORM', TEXT_PARAMETER,'NO');
RUN_PRODUCT(REPORTS, 'Report_Name.rdf',
SYNCHRONOUS,RUNTIME,FILESYSTEM, PL_ID);

END;

how do u compile a form i.e .fmb file in Unix or in dos

4578

---

can you convert or reverse engineer a fmx back to a fmb file?

1173

---

what is tripstop report?

1844

---

What is the difference between bind and lexical parameter?

1087

---

What do you understand by oracle forms?

1055

---

why the Ctl file u put only in bin folder why not in other folder

2054

---

Why oracle forms required?

1047

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1168

---

Can we invoke one form from another in a multi-forms application?

1143

---

how do u place it in required folder

1943

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2334

---

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

1704

---

What do you understand by lov and how can it be used?

1105

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

2047

---

what is a package n what r the packages availbla in report

2107

---