This discussion is archived
3 Replies Latest reply: Sep 20, 2011 9:05 PM by 879472 RSS

Lexical Parameters in WHERE clause giving error

879472 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points