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 COPY Operation

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], "b":[7,8,9]}',
         copy '$.c' =  path '$.b'
         create on missing
         error on null
         error on empty
      );

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