From: genericax@hotmail.com (Sara)
Newsgroups: comp.databases.oracle.server
Subject: Re: why is my query editor and command line out of sync?
Date: 12 Dec 2001 07:07:20 -0800
Organization: http://groups.google.com/
Lines: 31
Message-ID: <776e0325.0112120707.644c6e7b@posting.google.com>
References: <776e0325.0112061049.228f92c9@posting.google.com> <91884734.0112061729.7ee64dce@posting.google.com> <776e0325.0112111301.2064c5f4@posting.google.com>
NNTP-Posting-Host: 207.41.128.55
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1008169640 26781 127.0.0.1 (12 Dec 2001 15:07:20 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 12 Dec 2001 15:07:20 GMT


genericax@hotmail.com (Sara) wrote in message news:<776e0325.0112111301.2064c5f4@posting.google.com>...
> joel-garry@home.com (Joel Garry) wrote in message news:<91884734.0112061729.7ee64dce@posting.google.com>...
> > genericax@hotmail.com (Sara) wrote in message news:<776e0325.0112061049.228f92c9@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...