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

Ron Reidy <rereidy_at_indra.com> wrote in message news:<3C0FDC65.ED6A5F5C_at_indra.com>...
> Sara wrote:
> >
> > 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
> If you want mysql up/down arrow functionality, look at
> http://sourceforge.net/projects/yasql
>
> The rest of the problems are not described well enoght to give help with
> (i.e., Oracle version, platform, editor you are using, login.sql files,
> system wide login.sql settings)

SunOS 5.8
I'm on a Sun u-Sparc running SunOS 5.8, running Oracle 8i. I own and have full rights on the dirs I'm in. I also own and have rw rights on afedit.buf as well. To verify, I typed:

  SQLPLUS> edit

and edited the buffer, and saved and exited, then I more'ed the afedit.buf file and it did contain the changes I made. So there doesn't appear to be any priv issues. However, Oracle didn't use this buffer- its current query is, as I said, the last one entered at the SQL+ prompt. It ignores anything created in the editor. If I invoke the editor again, I see the changes.

Thanks, I'm all ears
GX Received on Tue Dec 11 2001 - 14:34:43 CST