Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: why is my query editor and command line out of sync?

Re: why is my query editor and command line out of sync?

From: Joel Garry <joel-garry_at_home.com>
Date: 27 Dec 2001 13:05:49 -0800
Message-ID: <91884734.0112271305.22ea7173@posting.google.com>


genericax_at_hotmail.com (Sara) wrote in message news:<776e0325.0112191035.73e2bceb_at_posting.google.com>...

> By the way- now the edit IS WORKING.. I don't know if our admin
> changed something, or maybe Im in another dir and its OK there? Oh
> well when it breaks again I'll revisit all of the items you listed for
> clues..
>

This now sounds very much like an environment variable issue, particularly the variable EDITOR. Make your admin fess up! :-)

Check the dates on files like /etc/profile, and .profile and .bashrc in your $HOME directory. Look for exports of EDITOR. Try setting it last in your .bashrc without exporting, see if that makes a difference. Try setting it to something besides /bin/vi (or whatever). The idea here is, it was set correctly for your primary shell, but when you executed a subshell by saying edit in SQL it did something else, or vice versa. The equivalent in csh would be .login and .cshrc, look for set and setenv, setenv is the equivalent of exporting. Exporting means making variables available to subshells, but if you have an rc file that resets variables it could be very confusing.

It could also have been in the oracle login that starts up oracle... if it is ksh, look for .profile and .kshrc files.

And remember, never use csh for production scripts! But don't believe me, see Unix Power Tools.

Enquiring minds want to know what the problem was!

jg

--
"San Diego desperately needs more tweakers." - columnist Neil Morgan's
neighbor, apparently not knowing alternative definitions of "tweaker."
Received on Thu Dec 27 2001 - 15:05:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US