How to pass lexical paramater for example &where_clause from forms 10g to report 10g using web

Interview Candidate
Oct 8th, 2007
3
6400

Showing Answers 1 - 3 of 3 Answers

rajivgupta780184
Profile Answers by rajivgupta780184 Questions by rajivgupta780184

Aug 11th, 2008

Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in Before Report.

For example:

IF :P_DATE_FROM IS NOT NULL AND :P_DATE_TO IS NOT NULL THEN
     :P_DATE := 'AND trunc(ccchv.transaction_costed_date) BETWEEN :P_DATE_FROM AND :P_DATE_TO';
ELSE IF
     :P_DATE_FROM IS NOT NULL AND :P_DATE_TO IS NULL THEN

     :P_DATE := 'AND trunc(ccchv.transaction_costed_date) BETWEEN :P_DATE_FROM AND SYSDATE';
ELSE
     :P_DATE := 'AND 1=1';
END IF;

Thanks
Rajiv Gupta