ORA-01008: not all variables bound
Posted: 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.
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.