Restituisci
-
Titolo
When running a statement in Toad 15, the error 'ORA 00923: FROM keyword not found where expected' appears, but not when the same statement is run in Toad 13.x or SQL*Plus. -
Descrizione
When running a statement in Toad 15, the error 'ORA 00923: FROM keyword not found where expected' appears, but not when the same statement is run in Toad 13.x or SQL*Plus. -
Causa
This may happen if one of the columns within the tables of the select statement is XMLTYPE.
Toad 15.0 and earlier, didn't support XMLTYPE and had to re-write queries in the background to use GetCLOBVal or XMLSerialize to change XMLTYPE into CLOB.
Toad 15.1 beta supports XMLTYPE and it no longer has to rewrite the queries (as long as Oracle client version is 12.2 or newer).
-
Risoluzione
Please try with the 15.1 beta version, with Oracle client version 12.2 or 18 (Preferably not 19c or 21c - that will work, but it suffers from memory leaks with LOBs so it is not ideal).
The beta version is available to download for testing purposes from here