Use Textpad for SQLPLUS editor

[Duane]

I can define _editor to use writepad or notepad but I cannot seem to get textpad to work as a default editor in sqlplus (to edit the buffer in the afedit.buf file).

Anyone accomplish this? Any ideas?

thanks!

[Stephen Waldock]

I can get it to work, but have to give the full path to the executable.

For me it also needs to be in the old dos style format.
ie. c:\progra~1\textpa~1\textpad.exe

[Duane]

Thanks!!! That worked!

sql> define _editor="c:\progra~1\textpa~1\textpad.exe"
sql> select user from dual;
...
sql> edit //(starts textpad, opens the afedit.buf file; I associated the .buf extension with plsql syntax. ta da!

thanks!