WebStorm | Database tool | PLSQL | JSON_OBJECT | Error JSON Standard Follow
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
Please sign in to leave a comment.
Hello,
I've created bug report, please follow and vote to get noticed on any updates.