question

Baxter1997-0164 avatar image
0 Votes"
Baxter1997-0164 asked Joyzhao-MSFT commented

Report Builder - ORA-01008: not all variables bound ODBC

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!

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KN-3316 avatar image
0 Votes"
KN-3316 answered KN-3316 edited

I had similar issue with SSRS - Visual Studio. some times for no reason it does. probably that is because of drivers not supported.

If I publish to SSRS - Reporting server and change to use Oracle client as data source connection instead of ODBC, that works with no issues.

Even if you see the ODBC error, try publishing it and test

So, I strongly feel, MS + ODBC has the problem

Regards,
KN

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @Baxter1997-0164 ,
From the perspective of RS, there seems to be no good solution. You can consult the oracle experts whether there are any good solutions.
Best Regards,
Joy

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Has your issue been resolved?

0 Votes 0 ·