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!

SQLcl: CONTEXT_DOESNT_EXIST after relaunching SQLcl

Oleg PyatnychkoApr 30 2025

Steps to reproduce:

  • launch SQLcl
  • initialize project (project init … )
  • leave SQLcl
  • launch SQLcl
  • run any project command (project verify…)
    • CONTEXT_DOESNT_EXIST

Re-running project init … in new SQLcl session kind of works, but I'm not sure it's the proper way to “fix” this.

Is this expected?

# sql -name DEV-LAB

SQLcl: Release 25.1 Production on Wed Apr 30 12:09:59 2025

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.8.0.25.05

LAB @ jdbc:oracle:thin:@DEV  > project verify
CONTEXT_DOESNT_EXIST

LAB @ jdbc:oracle:thin:@DEV  > project init -name LAB -schemas LAB -con DEV-LAB
ERROR: Project LAB already exist
/Users/olko/oci-lab-schema

LAB @ jdbc:oracle:thin:@DEV  > project verify
-------- Results Summary ----------
Errors:     2
Warnings:   1
Info:       4
---------------------------------
This post has been answered by Roel Hartman on May 6 2025
Jump to Answer
Comments
Post Details
Added on Apr 30 2025
2 comments
137 views