instant-client editor problems

From: Martijn <martijnm.bos_at_gmail.com>
Date: 10 Jan 2006 01:16:21 -0800
Message-ID: <1136884581.122233.221910@f14g2000cwb.googlegroups.com>

Hi All,

On one machine I have an oracle-instant-client installed. ( SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 10 09:41:29 2006)

This client I use to connect to several databases (
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.6.0 - Production
)

This is all on AIX 5.2.

The problem now occurs when using ed (See below snippet):

---

SQL> select * from dual;

D
-
X

SQL> ed
Wrote file afiedt.buf

  1* select * from dual
SQL>

---

No editor (vi) is opened to edit the sql.

In the profile of the user I have:
export EDITOR=/usr/bin/vi
set -o vi

And my question is: Does anyone have an idea how ro get the editor working "vi-like"?

Best regards,

Martijn Bos Received on Tue Jan 10 2006 - 03:16:21 CST