Re: SQL*Plus

Thanks for the response!!!

I've tried all of the suggestions below and everything seems to appear normal, but here is what is weird. When I invoke the editor, it appears to save whatever is in the buffer to afiedt.buf, then gives control to Notepad. I'll update my query, it'll ask me to save....then when control is returned to notepad, my updated query doesn't 're-post' to the SQL*Plus prompt/window. At this point, I can manually open the 'updated' afiedt.buf file in Notepad and see my changes, but if I invoke the editor again in SQL*Plus, it'll overwrite my updated query in afiedt.buf with the original query that is in the buffer.

The problem seems to be that when I invoke the editor, SQL*Plus seems to be writing whatever is in the buffer to afiedt.buf before opening Notepad. Then when I close Notepad, there is no 'hand-off' back to the SQL*Plus buffer with the updated query in afiedt.buf. I'm not sure if there is a environment/registry setting somewhere to fix this, or if I might just be better off re-installing the Oracle client. This problem just started occuring this week and I'm not aware of any setting that I might have altered. Any other suggestions would be appreciated!

Thanks again,
Buck Eskew

Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote in message news:3A02BACF.D53458F7_at_Unforgetable.com...
> Buck Eskew wrote:
>
> > Thanks for the response!
> >
> > I searched to see if I had another 'afiedt.buf' file on my harddrive,
 but
> > didn't find one. Also, I couldn't see anything in the glogin.sql file
 or
> > the Registry. It appears as though the 'buffer' is not reading the
 actual
> > afiedt.buf file. I can open the file from within Notepad and it shows
 my
> > revised query, but when I use the EDIT command in SQL*Plus, it brings up
 the
> > previous query.
> >
> > Any other ideas?
> >
> > Thanks
> >
>
> Keep in mind that afiedt.buf is just the default name. The name can be
 changed
> to something else - typically by a login.sql or glogin.sql. If you are
 able to
> do an EDIT and the current query comes up in notepad then there is some
 file
> being created somewhere, even if it isn't afiedt.buf. It "should" be in
 the
> current working directory, but there are ways around that if someone has
 messed
> with the registry. You might also want to check your c:\windows\temp
 directory
> to see if some file is being created there, but that is a long shot.
>
> Enter the command "show editfile" and see what it returns. If it says
> "afiedt.buf" then that is definitely the file that is being written
 somewhere.
>
> If you are using sqlplus for windows then you will want to check the
 shortcut
> that you are using to start sqlplus. If it has a directory that is
 explicitly
> named in the "start in" directory then that is overriding the current
 working
> directory.
>
> Determine whether SQLPATH is set somewhere in your environment or in the
> registry. That will also override the current working directory for
 certain
> things, but I've never heard whether it affects afiedt.buf.
>
> Something else to try. Define your editor as something other than notepad
 and
> see if that makes a difference. Wordpad would be a good choice, but you
 can also
> get any number of plain vanilla text editors from shareware sites.
>
> Those are about the only other things that I can think of..
>
Received on Fri Nov 03 2000 - 08:15:17 CST