I have an issue using parameterised reports connecting to Oracle using "ODBC" and "Microsoft OLE DB Provider for Oracle" using parameteried reports. The following error is generated "ORA-01008 not all variables bound (Microsoft OLE DB Provider for Oracle)" and a similiar one for ODBC. It works fine for simple reports. Do these 2 drivers have issues passing parameters for a remote Oracle query?
Thanks.
It could have something to do with the syntax you are using to pass the parameters. Oracle uses : (colon) instead of @. for SQL Server
See this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=679346&SiteID=1
|||Hi,
Cheers. Unfortunately that's not the issue. Have query like this:
"select unique change_id from change
where (change.change_id like :changeCategory)"
Any other ideas?
Thanks.
|||I'm not sure, but I think that depending on which provider you connect with you may need to change the named parameter syntax to unnamed. I think you replace you variable with a question mark (?)
You can give it a go. Other than that I can't really help - not my area of expertise.
