3 Replies Latest reply: Sep 20, 2011 11:05 PM by 879472 RSS

    Lexical Parameters in WHERE clause giving error

    879472
      Hi,

      Based on the parameters, I need to change the where clause of the sql query in the data model of the report. After report params I added the code like

      :p_where1 := 'conditions...';

      and in the select clause

      select table.name
      where &p_where1

      I added p_where1 as the user parameter.

      But When I say okay to the query in the data model. I am getting the error as

      ORA-00936: missing expression
      WHERE ==>

      Can anybody help me why I am getting this error..

      Thanks,
      HC