Return
-
Title
ORA-00904: "_xx_"."_xx_": invalid identifier -
Description
Can't execute old files in new versions.Creating a query in the Toad Data Point (TDP) 3.x Query Builder, and:1. - The query has subqueries and aliases for colums.2. - The query has an UNION statement to join the result of two subqueries.3. - The aliases of the columns being joined are created using LOWERCASE letters.The query runs fine using TDP 3.x, but, when opening the query using TDP 4.1, one may see that some aliases are in LOWERCASE letters and others are in UPPERCASE letters and the query does not run.PLEASE NOTE, change number QAT-12062, was created for the fact that version 3.8 converts aliases with white spaces in it to UPPERCASE, but, v4.3 doesn't. And again one can't execute old files in the new version.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.