Query with parameter value that is used in the select

[tonyyu888]

Hi,

I am porting a report from another reporting platform and was having problems.  Below is a simplified query (Oracle) similar to the actual query I am trying to port to SSRS.

select @test
from dual
where to_number(@test) = to_number(@test)

When running the above through the Design a query I get this:

ORA-00936: missing expression
ORA-00936: missing expression

It does not like the condition in the where clause.  Anyone got any idea on how to formulate this to work?

Let me know.

Thanks.

Tony

[#2 · Accepted solution]

For those who might be having the same issue.  Got this figured out.

For Oracle data sources, use : instead of @.