An error stating "List index out of bounds (0)" may occur when attempting to open the TNSNames Editor from TOAD. This error is a result of a corrupted or invalid entry in the TNSNAMES.ORA file not recognized by TOAD.
An example would be the following TNSNAMES.ORA entries containing spaces on the left hand side of the "=" sign and spaces to the right of the "=" sign:
The first one should fail due to the spaces between each value (after the commas). The second one should succeed.
1. D715, sas_d, pulse_d=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=pr01uc27.pr.wyeth.com)(Port=1515)))(CONNECT_DATA=(SID=D715)))
2. D715,sas_d,pulse_d=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=pr01uc27.pr.wyeth.com)(Port=1515)))(CONNECT_DATA=(SID=D715)))
WORKAROUND:
Remove any invalid entries in the TNSNAMES.ORA file. (ie: extra spaces on left hand side)
STATUS
This issue is fixed in TOAD 8.5. This version can be downloaded at http://questsupportlink.quest.com/prod_upgrade_alert.asp.
