Re: SQL * Plus Problem

David Boucher wrote:
>
> I am running SQl Plus on NT workstation 4.0, when I invoke the editor, it
> writes the buffer back immediately and I am unable to use editor to
> edit.........
> Has anyone had any experience with this problem? it seems to happen on all
> the NT4 machines.
>
> thxs
> Dave Boucher

Hi, I am working on NT 4.0 too.
Oracle changed behaviour of edit in SQL PLUS 3.3 ( to formerly 3.2 ) In 3.2 the user has been able to say

edit

which invokes the editor.
BUT and this is the difference : SQL Plus immediatly returned to command line input prompting for new command, after the editor was launched with afiedt.buf ( or whatsoever ).
To get your edited command started you had to use paste in the editor and copy in SQL PLUS or to quit the editor and start with _at_afiedt.buf in sql plus.

NOW under 3.3 SQL PLUS launched the editor AND WAITS until you complet editing !! ( I thing they have implemted this behaviour on strong user request which is not hard to understand ) After quiting the editor (saving your changes ) the file is reread into the command line buffer of sqlplus, thus allowing immidiat execution of the (edited) command.

What to do :
 If you don't like the way 3.3 handles it your only way ( out of my experience ) is to use
 clipboards cut in sqlplus (which is now supported over CTL-C and CTL-V !! )
 and paste in an previously started editor.

 I do it this way.

 BTW : I use Textpad as editor which is only $30 and allows multiple textwindows, line numbering , BLOCK mode selection, which is specialy helpfull in sql, because it means that you can cut an sql plus output, paste it, change your query , exec, cut again and paste it : ROW TO ROW beside the previous result. Very nice feature !!

Hope I got your problem right and you didn't waste time by reading this.

Cioa.
 Robo. Received on Sat Apr 19 1997 - 00:00:00 CEST