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!

Option to exclude some keywords from intellisense syntax checking (linter)

user12980594Apr 9 2024

An option to exclude (via regexp) some keywords from intellisense, would be useful.

Example:

oracledevtools.intellisense.exclude: "oserror "

I need it because lines like:
WHENEVER oserror exit SQL.OSCODE rollback
or
WHENEVER oserror exit SQL.OSCODE

are marked as errors (SQL*Plus syntax):

[{
"resource": "/process.sql",
"owner": "_generated_diagnostic_collection_name_#2",
"severity": 8,
"message": "Errore di sintassi alla riga 18, colonna 33. Previsto: '(',paren_expr_list,'.',';',':','%',WHEN_cond_opt,",
"source": "dbtools",
"startLineNumber": 18,
"startColumn": 34,
"endLineNumber": 18,
"endColumn": 37,
"relatedInformation": [
{
"startLineNumber": 18,
"startColumn": 34,
"endLineNumber": 18,
"endColumn": 37,
"message": "Errore di sintassi alla riga 18, colonna 33\n\n\nWHENEVER oserror exit SQL.OSCODE rollback\n ^^^ \n\nPrevisto: '(',paren_expr_list,'.',';',':','%',WHEN_cond_opt,",
"resource": "/process.sql"
}
]
}]

Comments
Post Details
Added on Apr 9 2024
1 comment
274 views