Toad Tnsnames Editoris missing part of entries after Comment. This can be verified by using the tnsnames editor option in TOAD under the TEXT Editor tab. Formatting gets disrupted and TNS entries get messed up.
Tnsnames.ora shown in notepad:
xxxxxxxxxxxx =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxxxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
#(SERVICE_NAME = xxxxxxxxxxxxxxx)
(SID = xxxxxxxxxxxxx)
)
)
Tnsnames.ora shown in Toad Tnsnames Editor:
xxxxxxxxxxxx =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxxxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
))
#(SERVICE_NAME = xxxxxxxxxxxxxxx)
SID =
In Toad 10.6.1, this works fine.
WORKAROUND:
None.
STATUS:
Issue fixed in version 12.0. The latest version of Toad for Oracle can be downloaded here.
