can any one help me how to create lexical parameters in oracle d2k reports for writing dynamic where condition during run time.
I have tried by creating a user parameter called p_where.
Then i have written a Query as follows.
select deptno,dname from dept
But i am getting the error Invalid SQL statement
So Please tell me what else i have to write after creating the parameter.
ie Any Validations, any Libraries or any Before & after form triggers, I am unable to find a correct article regarding this, Thanking u in advance.