SSRS ORA-01008: not all variables bound when I add a variable?

Question

User-1957998148 posted

From the vs.net as an ssrs project, I have this simple query:

 

select * from mytablel where mykeyr=&p1 

I get this error:

An error occurred while executing the query.
ORA-01008: not all variables bound
------------------------------
ADDITIONAL INFORMATION:
ORA-01008: not all variables bound
 (System.Data.OracleClient)

I've tried connect type Oracle and OLEDB. 

 

Of course if I remove the variable the error goes away.

Thanks for any help or information.
 

 

Answer 1

User-1853239823 posted

what I do Is:

Not to write Querys in part of Query, otherwise like a Expression example beside you write in Query select :parameter, field1 from table you have to write in Expression ="SELECT ' "& Parameters!fecha.Value   & " ' field1 FROM table"