Using LOGI 14; Displaying charts and tables, we have some Oracle queries that take too long to run with a DataLayer.SQL element. The SQL uses common table expressions (CTE); Using ActiveSQL data layers is much faster, but if the query has a CTE - we get ORA-00972: identifier is too long message. There is NO identifier that is too long in the CTE or anywhere else in the query;
The query runs fine in an IDE/sqlplus.
We have many queries with CTEs in another analytics tool, and we don't want to rewrite them when (if) we port them to LOGI.
with x (x) as (select x from x)
select <col list>
from x join <table>
Please sign in to leave a comment.