Re: Personal Oracle7 (SQL*Plus Editor)
Date: 1995/04/19
Message-ID: <3n3tlp$c3g_at_ixnews4.ix.netcom.com>#1/1
In <D7AMEC.8pB_at_westminster.ac.uk> mgyec_at_westminster.ac.uk (Mike Megan)
writes:
>
>I'm having trouble getting the "EDIT" command to work with SQL*Plus
>for *Windows* which came as part of the Personal Oracle7 package.
>
>I have tried using the following commands:
>
>DEFINE _EDITOR NOTEPAD
>DEFINE _EDITOR NOTEPAD.EXE
>DEFINE _EDITOR C:\WINDOWS\NOTEPAD.EXE
>DEFINE _EDITOR C:\DOS\EDIT
>...etc.
>
>None of these work.
>
>I would be grateful for any suggestions
>Thanking you in advance,
>
>Michael Megan
>mgyec_at_westminster.ac.uk
I've had similar problems connecting SQLPLUS for Windows to a remote database server. It seems to work fine the first time, but afterwards always creates a DOS shell immediately terminates on subsequent EDITs.
What I do to get around it is to keep a notepad window open and enter all my SQL commands into that. Then copy and paste to SQLPLUS.
><> Chuck <>< Received on Wed Apr 19 1995 - 00:00:00 CEST