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;

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

2227