3 Replies Latest reply on Sep 21, 2011 4:05 AM by 879472

    Lexical Parameters in WHERE clause giving error


      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..