Skip to Main Content

SQL Developer for VS Code

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!

Bug: Syntax Error When Using a Substitution Variable in CREATE CONTEXT Statement

The next script can be saved, e.g., as “test.sql,” and successfully executed via SQLcl or SQL*Plus. It also works via “Run Script (F5)” in VS Code. However, it produces a syntax error in the VS Code extension 24.3.1.

-- set substituation variable
define prefix = "app"

-- create procedure using a substition variable (no syntax error in VS Code)
create or replace package &&prefix._pkg is end;
/

-- create context using a substitution variable (syntax error in VS Code)
create or replace context &&prefix._ctx using &&prefix._pkg;

Here's the screenshot showing the complete error message:

This post has been answered by Philipp Salvisberg on Apr 15 2025
Jump to Answer
Comments
Post Details
Added on Dec 15 2024
1 comment
151 views