WebStorm | Database tool | PLSQL | JSON_OBJECT | Error JSON Standard



I am editing a SQL file that contains Oracle PLSQL.

I have the following code:

'status' VALUE '200',
'message' VALUE 'Contract Added'
INTO action_result
FROM dual;

The code analysis shows me 3 errors about JSON standard:

  • does not allow such tokens
  • allows only one top-level value
  • does not allow such tokens

All on the same line: the one with "message VALUE".

It considers that the 'Contract Added' is not "valid"

The PLSQL work as expected when executed against the database (using SQL Developer)

Any idea why?

Thank you
Webstorm: 2021.3 (WS-213.5744.224) + Database tools and SQL for WebStorm

1 comment
Comment actions Permalink


I've created bug report, please follow and vote to get noticed on any updates.


Please sign in to leave a comment.