Re: "ed" command doesn't work under SQL*PLUS???

On 10-Jun-98 14:57:38 Xoi Tang wrote:

>Hi, everyone:

>I'm a new comer of Oracle. Here's my question:

>In SQL*PLUS 3.22(Personal Oracle 7.3.2 under NT 4.0 server &
>workstation, IBM-PC), something is wrong when I try to use "ed" to open
>"NotePad" to edit the latest command I input.

>For example: first I input "select * from department", then type "ed",
>but after I changed the command to "select * from student" and saved
>it, then I use "\", it still ran the old command which is "select *
>from department".

>I check the property of that buffer file, unchecked "Archive"
>attribute, and tried it again. It still failed, and property is changed
>back to "Archive".

>I think this is some problem of configuration.

>Anybody help me?

>Thanks a lot!

Hello,
I think it's not an Oracle Problem but one of NT. When SQl*Plus gets the ^ed^ command it starts the editor waits for it to terminate and rereads the afiedt.buf.
Here comes the problem with NT (I think): Notepad.exe seems to detach from the calling process so the SQL*Plus rereads the buffer immediately after the notepad has started.
The solution is perhaps to use another editor which can be launched synchronely from SQL*Plus.

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |