OraFAQ Forum: Client Tools » Not getting Editor from sqlplus*

Home » Other » Client Tools » Not getting Editor from sqlplus* (Windows 7 and oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not getting Editor from sqlplus* [message #541185]

Sun, 29 January 2012 04:45

morad_dba
Messages: 93
Registered: June 2008

Member

Dear all,

I am using Windows 7 and oracle 10g; From sqlplus* I can not use editor (using ed).

but when I see the variable from DEFINE.. It shows that default editor is notepad..

Note: I can use editor in winxp.

Pls tell me... How to get (use) editor ?

Regards,
Morad.

Report message to a moderator

Re: Not getting Editor from sqlplus* [message #541189 is a reply to message #541185]

Sun, 29 January 2012 06:57

Solomon Yakobson
Messages: 3303
Registered: January 2010
Location: Connecticut, USA

Senior Member

In SQL*Plus issue

define _editor

and check output. For example:

SQL> define _editor
DEFINE _EDITOR         = "Notepad" (CHAR)
SQL>

Then in command window or using sqlplus HOST command try starting editor that shows us in define _editor output:

host notepad

If editor window doesn't appear make sure editor is on the %PATH%.

SY.

[Updated on: Sun, 29 January 2012 07:00]

Report message to a moderator

Previous Topic:	Unable to Print The Query Output On TOAD
Next Topic:	REF CURSOR to print output from given input

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:04:37 CST 2025