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 JSON_TRANSFORM With UNION Operation And ERROR ON MISMATCH Option

The following statement works in Oracle Database 23ai but produces a syntax error in the VS Code extension 24.3.1.

select json_transform(
          '{"a":[1,2,3,4,5,6,6], "b":[4,1,3,5,7]}',
          union '$.a' = path '$.b[0 to 4]' format json
          ignore on missing
          error on mismatch
          ignore on null
       );

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
102 views