Andy, Anthony, thank you very much for your information.
Not to my knowledge no. As far as I'm aware both SQL Developer and TOAD do exactly that. Of course it gets trickier if you've got multiple Oracle homes and therefore more than one tnsnames.ora file.
That was what I had in mind --- TOAD displays the Oraclehomes, and partially also the TNS-names. I was really hoping there is a way to detect that; building a setup helper for an application. So, thanks for sparing me the futil search ! Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.
_______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig