PR - Fails when using some substitution variables
Before I get started, I will list the versions of the software.
Versions...
SQR 11.1.2.0.0.100 ( for Oracle )
Oracle : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
DB Driver : 10.2.0 Oracle driver (10g Client)
In one of my reports, I get the following error message when trying to run the report
ORA-00920: invalid relational operator
This is caused by the report cutting off most of the SQL when it tries to compile it. What is happening is that the SQL in the query after and including the [] substitution variable is being ignored. As a result, the SQL becomes invalid and the error occurs. I will show you the example of code that is in my report. In my example, I will show you my SQL starting with the FROM clause within the begin-select command.
Versions...
SQR 11.1.2.0.0.100 ( for Oracle )
Oracle : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
DB Driver : 10.2.0 Oracle driver (10g Client)
In one of my reports, I get the following error message when trying to run the report
ORA-00920: invalid relational operator
This is caused by the report cutting off most of the SQL when it tries to compile it. What is happening is that the SQL in the query after and including the [] substitution variable is being ignored. As a result, the SQL becomes invalid and the error occurs. I will show you the example of code that is in my report. In my example, I will show you my SQL starting with the FROM clause within the begin-select command.
0