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

  • 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
    ORA-01008: not all variables bound

    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.


    Tuesday, September 4, 2007 11:08 PM

All replies

  • 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"

    Tuesday, November 13, 2012 2:19 PM