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.
ORA-01008: not all variables bound
-
- Posts: 23
- Joined: Wed Sep 25, 2019 7:19 pm
ORA-01008: not all variables bound
- Attachments
-
- ORA-01008_Not_all_variables_bound.PNG (73.69 KiB) Viewed 11154 times
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: ORA-01008: not all variables bound
Hello,
Which data source type is used?
Also, please try to check:
https://stackoverflow.com/questions/749 ... -are-bound
Thank you.
Which data source type is used?
Also, please try to check:
https://stackoverflow.com/questions/749 ... -are-bound
Thank you.
-
- Posts: 23
- Joined: Wed Sep 25, 2019 7:19 pm
Re: ORA-01008: not all variables bound
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
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
- Attachments
-
- Workaround_for_ORA-01008_Not_all_variables_bound.PNG (48.2 KiB) Viewed 11105 times
-
- Posts: 23
- Joined: Wed Sep 25, 2019 7:19 pm
Re: ORA-01008: not all variables bound
Hi Lech,
I have reviewed the link, thank you. Maybe it will help me in future, if my current workaround would not work anymore.
Regards,
Denis.
I use Oracle data source for all my reports.Lech Kulikowski wrote: ↑Thu Jan 16, 2020 7:55 pm Hello,
Which data source type is used?
Also, please try to check:
https://stackoverflow.com/questions/749 ... -are-bound
Thank you.
I have reviewed the link, thank you. Maybe it will help me in future, if my current workaround would not work anymore.
Regards,
Denis.
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: ORA-01008: not all variables bound
Hello
Ok.
Please let us know if you need any additional help.
Thank you.
Ok.
Please let us know if you need any additional help.
Thank you.