Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why is my query editor and command line out of sync?
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... Received on Tue Dec 11 2001 - 15:01:42 CST