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;

what is oracle forms?

1105

---

what is the difference between call_form, new_form and open_form?

1309

---

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

2098

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2023

---

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2164

---

Name the different triggers supported by oracle reports and their firing order.

1092

---

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

2329

---

What is the difference between bind and lexical parameter?

1079

---

In what sequence do triggers get fired by oracle forms?

965

---

List out the oracle forms configuration files?

1072

---

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

2135

---

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

1133

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2287

---

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

1888

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1978

---