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.
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"
jcnet
Member
572 Points
345 Posts
SSRS ORA-01008: not all variables bound when I add a variable?
Sep 05, 2007 03:08 AM|LINK
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.
Yisus Lopz
Member
2 Points
1 Post
Re: SSRS ORA-01008: not all variables bound when I add a variable?
Nov 13, 2012 06:19 PM|LINK
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"