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
List the different types of columns in oracle reports.
what are the new features introduced in oracle form services in 11g release 2?
what is tripstop report?
What is the difference between bind and lexical parameter?
if u want to delete all these detail block etc what will happen in form
Explain the different levels at which oracle form services interact.
Is it possible to have multiple layouts in a report?
What do you understand by oracle forms and why are they required?
Is it possible to execute a dynamic sql from forms?
how do u compile a form i.e .fmb file in Unix or in dos
what is a package n what r the packages availbla in report
What are the various configuration files that are used by oracle forms?
In what sequence do triggers get fired by oracle forms?
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
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
