ORA-01008: not all variables bound

[denis.awfm]

Hi Support.
I have seen the ORA-01008: not all variables bound error when tried to implement the additional filtering on the dataset inside SQL query, using date variables value as parameters (to speed up rendering of the report because if filtering is done on Data Band then a lot of data is queried first into the report from remote database which is significantly slower than filtering via SQL parameters).
As seen in the attached screenshot.
Same error happens in 2020.1 Designer as well.
Please advice if there is the solution for this issue.
Regards,
Denis.

[Lech Kulikowski]

Hello,

Which data source type is used?

Also, please try to check:
https://stackoverflow.com/questions/749 ... -are-bound

Thank you.

[denis.awfm]

Hi Support.

Just a follow-up:
I have discovered a workaround, which avoids creation of ORA-01008 error.
In SQL of the Query I put the filter " and (D.SHIFT_START_SCH >= :PScheduledStart) and (D.SHIFT_END_SCH <= :PScheduledEnd) " BEFORE the filter for :PReportNo
And it worked without any ORA-01008, so the Query opened and returned data without errors

Also important thing to remember is that parameters must be defined in Query in SAME order as they appear in the SQL text.
In my example, those are :PScheduledStart then :PScheduledEnd then :PReportNo

[denis.awfm]

Hi Lech,

Hello,

Which data source type is used?

Also, please try to check:
https://stackoverflow.com/questions/749 ... -are-bound

Thank you.

I use Oracle data source for all my reports.
I have reviewed the link, thank you. Maybe it will help me in future, if my current workaround would not work anymore.

Regards,
Denis.

[Lech Kulikowski]

Hello

Ok.
Please let us know if you need any additional help.

Thank you.