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

Answered

Hello,

I am editing a SQL file that contains Oracle PLSQL.

I have the following code:

SELECT JSON_OBJECT(
'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

Hello,

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

1

Please sign in to leave a comment.