Solved

toad error list index out of bounds(0)

Posted on 2006-11-30
2
11,362 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
DLyall earned 500 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

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…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

724 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