Re: Using "whenever oserror" on Windows

Hi, Vsevolod,

You may try creating the file tnsnav.ora under %oracle_home%\network\admin. I'm documenting my way to identify this file in case other people are interested.

In the test.sql file, I say "whenever oserror continue rollback" so I don't have to login repeatedly. I type "conn yong/yong" to get the "O/S Message: No such file or directory" message, followed by "Connected" and "Rollback complete".

Now I launch filemon (from sysinternals.com), apply filter d:\ora9i\* since I know it mostly likely is a file missing from that folder and down, and type "conn yong/yong" in sqlplus. Filemon.log shows a dozen lines of "FILE NOT FOUND" for sqlplus.exe process. I try each one and find that creating tnsnav.ora eliminates the error. Tedious? Maybe. But it's systematic.

Yong Huang
yong321ATyahoo.com Received on Wed Apr 06 2005 - 00:12:38 CDT