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

     

    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