RE: using vim as SQL*Plus editor on Windows

  • From: "GBA_DBA" <galo.balda@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 5 Jul 2004 14:11:58 -0500

 
Thank you both Lyubomir and Lex for your replies. I installed Vim 6.3 and
now works using vim or gvim.

Regards
GBA

-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En
nombre de Lex de Haan
Enviado el: Lunes, 05 de Julio de 2004 13:08
Para: Oracle-L@Freelists. Org
Asunto: using vim as SQL*Plus editor on Windows

Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I remember a recent thread about the above topic, where the issue was that
all changed made in the editor were not reflected in the SQL buffer in
SQL*Plus. I think I know why:

if you define the _EDITOR as gvim, and you use the EDIT command from
SQL*Plus, SQL*Plus first launches a DOS command box and from there the GUI
vim window -- but then the DOS box is immediately closed, so SQL*Plus thinks
the editing session is over. Just watch the SQL*Plus window: the "SQL>"
prompt comes back, while it shouldn't -- it should wait until your editing
session is over.

the solution: don't use gvim, but use "regular" vim instead:

SQL> DEFINE _EDITOR='vim -c "set filetype=sql"'

works like a charm, including nice SQL-sensitive coloring...
(I am using vim6.3, oracle10g, Windows XP)

Kind regards,
Lex.

---------------------------------------------
visit my website at http://www.naturaljoin.nl
---------------------------------------------




-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-vcard
-- File: Lex de Haan.vcf


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: