?
Solved

toad error list index out of bounds(0)

Posted on 2006-11-30
2
Medium Priority
?
11,511 Views
Last Modified: 2013-12-12
When i try to click tnsnames editor from toad window i get a  toad error :list index out of bounds(0).Why is this and how to solve this
0
Comment
Question by:suhinrasheed
2 Comments
 
LVL 6

Accepted Solution

by:
DLyall earned 2000 total points
ID: 18044091
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.

Remove any invalid entries in the TNSNAMES.ORA file. (ie: extra spaces on left hand side)

This issue is fixed in TOAD 8.5.
0
 

Author Comment

by:suhinrasheed
ID: 18044130
Full marks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month14 days, 22 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question