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;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain how one can iterate through items and records in a specified block?
where do u put the report file
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
why the Ctl file u put only in bin folder why not in other folder
i am writing a query select EmpNo from Emp how can i call in after parameter form
What do you understand by lov?
In what sequence do triggers get fired by oracle forms?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What is an oracle report?
what are the oracle forms services components include?
what is oracle forms?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
all steps of bitmap report?
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
How can we generate report output in excel format?