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!

SQLcl statusbar default - not showing defaults when setting to ON

Arvydas KoOct 2 2025 — edited Oct 17 2025

SQLcl version 25.2

Either using startup.sql script, or simply starting SQLcl.
Setting status bar defaults and turning statusbar on does not show the default elements.
Example from user's guide section 6.4.1:

set statusbar default project cwd
set statusbar on

Status bar shows elements that are not default elements

SQL> show statusbar
STATUS BAR: on
Used components:
        EDITMODE
        LINECOL
        USERNAME
        DBID
<...>
Default components:
        PROJECT
        CWD

Another issue, project component is not shown, if set statusbar default is called before set statusbar on

set statusbar default project
set statusbar default
set statusbar on

This is resolved by executing set statusbar default after set statusbar on

set statusbar default project
set statusbar on
set statusbar default

Update:
Managed to get an exception when set statusbar default is called before set statusbar on .
If set statusbar default is omitted, or is called after set statusbar on, show project works as intended.

SQL> set statusbar default project
SQL> set statusbar default
SQL> set statusbar on
SQL> show project
2025-10-02 17:28:18.037 SEVERE oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run oracle.dbtools.extension.project.core.config.ProjectConfig.getCWD(ProjectConfig.java:182)
java.lang.RuntimeException: CONTEXT_DOESNT_EXIST
at oracle.dbtools.extension.project.core.config.ProjectConfig.getCWD(ProjectConfig.java:182)
at oracle.dbtools.extension.project.core.config.ProjectConfig.getCurrentWorkingProjectRoot(ProjectConfig.java:172)
at oracle.dbtools.extension.project.core.config.ProjectConfig.getCurrentWorkingProjectName(ProjectConfig.java:161)
at oracle.dbtools.extension.project.commands.show.ShowProject.handleShow(ShowProject.java:56)
at oracle.dbtools.raptor.newscriptrunner.commands.show.ShowRegistry.processShowCommand(ShowRegistry.java:217)
at oracle.dbtools.raptor.newscriptrunner.commands.Show.handleEvent(Show.java:46)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:437)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:241)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:835)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:124)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:1392)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1651)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:372)

Added on Oct 2 2025

4 comments

95 views