OraFAQ Forum: SQL & PL/SQL » In sql scripts, problem with define

Home » SQL & PL/SQL » SQL & PL/SQL » In sql scripts, problem with define_editor command

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

In sql scripts, problem with define_editor command [message #9069]

Thu, 16 October 2003 11:20

sancha
Messages: 31
Registered: October 2003

Member

Hi ppl

I tried define_editor command in the sqlplus environment.

sql> define_editor='dummy_editor"

the next time i try ed in the sql prompt, i get a a momentory flickering of dos style window and then it disappears.

Someone pls tell me why it happens this way.

bfn

Report message to a moderator

Re: In sql scripts, problem with define_editor command [message #9070 is a reply to message #9069]

Thu, 16 October 2003 11:31

Thiru
Messages: 1089
Registered: May 2002

Senior Member

thats becos its trying to execute 'dummy_editor' in the dos window and closes immediately as it cant find it.

Try notepad

-Thiru

Report message to a moderator

Re: In sql scripts, problem with define_editor command [message #9071 is a reply to message #9070]

Thu, 16 October 2003 11:34

sancha
Messages: 31
Registered: October 2003

Member

hi

thnx for ur response.
but how do i specify the kind of editor to notepad or dos editor?

bfn

Report message to a moderator

Re: In sql scripts, problem with define_editor command [message #9072 is a reply to message #9071]

Thu, 16 October 2003 12:05

Thiru
Messages: 1089
Registered: May 2002

Senior Member

define _editor=notepad

notepad is usually in the path.

-Thiru

Report message to a moderator

Re: In sql scripts, problem with define_editor command [message #9073 is a reply to message #9072]

Thu, 16 October 2003 12:10

sancha
Messages: 31
Registered: October 2003

Member

thanx again, thiru.

but, what if i insist on getting a dos type editor for the same. then what changes should i make?

(i am working in windows environment)

Report message to a moderator

Re: In sql scripts, problem with define_editor command [message #9074 is a reply to message #9073]

Thu, 16 October 2003 12:25

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Wow ! you like DOS so much ... use EDIT instead of notepad. Edit is a Dos editor,I believe.

define _Editor=edit

-Thiru

Report message to a moderator

thnx thiru [message #9075 is a reply to message #9074]

Thu, 16 October 2003 12:28

sancha
Messages: 31
Registered: October 2003

Member

thnx a lot, thiru.
ur solution certainly works spot-on.
thnx again

Report message to a moderator

Re: In sql scripts, problem with define_editor command [message #9936 is a reply to message #9074]

Mon, 15 December 2003 22:54

sancha
Messages: 31
Registered: October 2003

Member

Hi,

The following command doesnt work

sql>define_editor=textpad

now, when i try

sql>ed

the textpad(i guess) flickers for a second and disappears.

pls help!

bfn

Report message to a moderator

Re: In sql scripts, problem with define_editor command [message #9938 is a reply to message #9936]

Tue, 16 December 2003 00:31

Cheeku
Messages: 17
Registered: November 2003

Junior Member

Hi Sancha,
try giving the complete path of your textpad.exe file like
SQl>Define_editor = "C:ProgramFilesTextPad4TextPad.exe
It shud work.
Any probs you can revert back

Report message to a moderator

Re: In sql scripts, problem with define_editor command [message #9939 is a reply to message #9069]

Tue, 16 December 2003 01:53

sancha
Messages: 31
Registered: October 2003

Member

Posted by Cheeku (202.144.48.206) on December 16, 2003 at 04:31:36:
In Reply to: Re: In sql scripts, problem with define_editor command posted by sancha on December 16, 2003 at 02:54:45:

Hi Sancha,
try giving the complete path of your textpad.exe file like
SQl>Define_editor = "C:ProgramFilesTextPad4TextPad.exe
It shud work.
Any probs you can revert back

Hi cheeku,

thanx for your solution. Now i am able to work with textpad as the default one.

thnk u.

Report message to a moderator

Previous Topic:	Spool to different file by differnt group of data
Next Topic:	Query Ocasionally hangs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 15 13:34:07 CDT 2025