did you save your text in your editor ?
filename afiedt.buf
"Sara" <genericax_at_hotmail.com> schreef in bericht
news:776e0325.0112111234.47adf372_at_posting.google.com...
> 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 Mon Dec 17 2001 - 23:55:53 CST
