Hi,
I am having some issues with Report Builder where if I use multiple Parameters within a single dataset it returns the error ERROR [07001] [Oracle][ODBC][Ora]ORA-01008: not all variables bound
Query works fine within Oracle SQL Developer and strangely also works fine when building small datasets that contain one or two parameters in report builder.
I am confident that all parameters are being bound and set up correctly within report builder as I am able to successfully build other datasets that don't contain as many variables. I was also able to successfully run the report if I hard coded 2/4 variables, which makes me think it's either a bug or a dodgy ODBC driver.
Happy to share the code if required, wondering if anyone else has come across parameterisation issues when using ODBC within Report Builder? Thanks!