When creating a query in the SQL Modeler, I receive an "Unrecognized construct or syntax error..." error when trying to execute it in the SQL Modeler window. If I copy the query to the Editor and execute it, I get a "Ora-00920: invalid relational operator" error.
When a query is built using a SQL Function in the where clause, SQL Modeler inserts the column name in the wrong place.
WORKAROUND:
Copy the query to the editor and remove the column name that was inserted just before the SQL Function in the query.
Example-
SELECT Table1.NUM, Table1.FNAME
FROM Table1
WHERE ( (Table1.FNAME SUBSTR( Table1.FNAME , 1,2) IN ( 'Mi', 'Ed' )) )
should be
SELECT Table1.NUM, Table1.FNAME
FROM Table1
WHERE ( (SUBSTR( Table1.FNAME , 1,2) IN ( 'Mi', 'Ed' )) )
STATUS:
Waiting for fix to be released in a future version of SQL Navigator
Defect ID for SQL Navigator is ST3489.
Defect ID for Toad for Oracle is QCM33984.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy