Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

The external editor (terminal editor) does not start in sqlcl (version 23.26.1.0.0)

Markus WeberMay 4 2026

The process can only be aborted with Ctrl-C.

The file afiedt.buf is created and contains the correct content.

VS Code (code) works, but who wants to launch VS Code from the terminal…

SQL> select * from dual;
D
-
X
1 Zeile ausgewählt.
SQL> define _EDITOR=vim
SQL> ed
-- ctrl-c 
 1* select * from dual;
SQL>
SQL> define _EDITOR=vi
SQL> ed
-- ctrl-c 
 1* select * from dual;
SQL>
SQL> define _EDITOR=not_valid_editor
SQL> ed
java.io.IOException: Cannot run program "not_valid_editor" (in directory "/Users/markus"): error=2, No such file or directory
    at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1170)
    at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1089)
    at oracle.dbtools.raptor.scriptrunner.cmdline.editor.EditCommand.processExternalEditor(EditCommand.java:176)
)
... 16 more
 1* select * from dual;

VS code … :-(

SQL>
define _EDITOR=code
ed
 1* select * from dual;
SQL>

regards
Markus

Comments
Post Details
Added on May 4 2026
4 comments
108 views