Re: why is my query editor and command line out of sync?

genericax_at_hotmail.com (Sara) wrote in message news:<776e0325.0112111301.2064c5f4_at_posting.google.com>...
> joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0112061729.7ee64dce_at_posting.google.com>...
> > genericax_at_hotmail.com (Sara) wrote in message news:<776e0325.0112061049.228f92c9_at_posting.google.com>...
> > > I'm in sqlplus, and I enter a query then execute it. Then I type
> > > "edit" and the query the pops up in the editor isn't the one I just
> > > used.
> > >
> > > Also, when I exit the editor, and press "/-ret", it executes the
> > > previous sql command that I typed at the sqlplus prompt. It totally
> > > ignores what I just created in the editor.
> > >
> > > mysql up-arrow to retrieve and edit sql commands is about 1000 times
> > > easier than this, and the fact that it WORKS is nice too...
> > >
> > > GX
> >
> >
> > You didn't say what platform you are on, because it probably will make
> > a difference. I would guess you have a file with the same as the one
> > Oracle is trying to create, owned by someone else (perhaps you are the
> > owner, but Oracle is the user trying to change this file). Look for a
> > file named something like afiedt.buf in your default or current
> > working directory.
> >
> > jg
>
>
> Oh sorry I forgot to mention I'm editing with vi, and I have no login.sql files...

Oops sorry Im running Oracle 8i on a Sun Sparc running SunOs 5.8... Received on Wed Dec 12 2001 - 09:07:20 CST