ORA-01008: not all variables bound

Stimulsoft Reports.Java discussion
Post Reply
denis.awfm
Posts: 21
Joined: Wed Sep 25, 2019 7:19 pm

ORA-01008: not all variables bound

Post by denis.awfm » Mon Jan 13, 2020 9:06 pm

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.
Attachments
ORA-01008_Not_all_variables_bound.PNG
ORA-01008_Not_all_variables_bound.PNG (73.69 KiB) Viewed 975 times
Lech Kulikowski
Posts: 2702
Joined: Tue Mar 20, 2018 5:34 am

Re: ORA-01008: not all variables bound

Post by Lech Kulikowski » 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.
denis.awfm
Posts: 21
Joined: Wed Sep 25, 2019 7:19 pm

Re: ORA-01008: not all variables bound

Post by denis.awfm » Thu Jan 16, 2020 7:58 pm

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
Attachments
Workaround_for_ORA-01008_Not_all_variables_bound.PNG
Workaround_for_ORA-01008_Not_all_variables_bound.PNG (48.2 KiB) Viewed 926 times
denis.awfm
Posts: 21
Joined: Wed Sep 25, 2019 7:19 pm

Re: ORA-01008: not all variables bound

Post by denis.awfm » Thu Jan 16, 2020 8:01 pm

Hi Lech,
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 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
Posts: 2702
Joined: Tue Mar 20, 2018 5:34 am

Re: ORA-01008: not all variables bound

Post by Lech Kulikowski » Sun Jan 19, 2020 9:57 pm

Hello

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

Thank you.
Post Reply