REPOST: Re: backspace doesn't work in sqlplus

From: Andy Campbell <andy_at_starsend.force9.co.uk>
Date: Sun, 30 Dec 2001 16:36:14 +0000
Message-ID: <0$--$$-$$_%_%%%-$$@news.noc.cabal.int>

ORACLE_TERM was not set.

However just solved the problem. I noticed that I was getting the same problem with vi. But is was okay in other accounts on the box.

I was setting stty erase ^H in my .profile. However without an stty setting for erase it works fine !

Thanks for the reply
Andy

In article <gdeu2u0tinvfc0taq3kideuiau4fjms0rm_at_4ax.com>, "Bruno Jargot" <see_at_reply.to.invalid> wrote:

> On Sun, 30 Dec 2001 14:57:48 +0000, Andy Campbell wrote:
>

>>Hi,
>>
>>I'm using a sqlplus on LINUX and for some reason backspace doesn't work
>>from sqlplus.  It's works fine from the OS but turns into ^? as soon as
>>I enter sqlplus.
>>
>>I can do !stty erase ^H from sqlplus, but thats annoying everytime.  I
>>could add it to my glogin.sql but its a bit of a hack.

>
> I think that your problem comes from the ORACLE_TERM variable. Under the
> shell, TERM is used but under sqlplus, ORACLE_TERM is probably used if
> defined.
>
> Try with an undefined ORACLE_TERM.

WAS CANCELLED BY =======: Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!newsengine.sol.net!uwm.edu!newsfeed.cs.wisc.edu!newsfeed.mathworks.com!wn3feed!worldnet.att.net!198.6.0.123!uunet!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: "Andy Campbell" <andy_at_starsend.force9.co.uk> Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <UlHX7.11150$ll6.1611250_at_news6-win.server.ntlworld.com> Control: cancel <UlHX7.11150$ll6.1611250_at_news6-win.server.ntlworld.com> Date: Mon, 31 Dec 2001 06:29:40 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.UlHX7.11150$ll6.1611250_at_news6-win.server.ntlworld.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009788843 26548 166.102.15.34 (31 Dec 2001 08:54:03 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 08:54:03 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes

This message was cancelled from within Mozilla...not Received on Sun Dec 30 2001 - 10:36:14 CST