When right-clicking on a SQL query statement and Refactor | “Convert to ANSI Join Syntax” is selected, one or both of the errors below are received.
ERRORS:
1)
Failed to convert
2)
List index out of bounds (-1).
Example Query:
SELECT spriden_first_name, spriden_last_name, spraddr_city
FROM spriden, spraddr
WHERE spriden_pidm = spraddr_pidm
AND spriden_change_ind IS NULL
AND spriden_last_name = 'Smith';
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for Oracle.
