Solved

toad error list index out of bounds(0)

Posted on 2006-11-30
2
11,264 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 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

837 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