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!

Issue with Copy/Export Json

1687396Jul 27 2026

First of all, I am really liking the VSCode Extension for SQL Developer.

I did come across a unique issue when building a query though, it outputs a very large json with up to 5 levels of nesting arrays and multiple hundreds of results all in a single column & row. If I attempt to export the file out as a json, it will cut off the the the result in the column almost like it hits character limit. I even just tried to Ctrl + C the result into the workspace. I then tested this over in the Vanilla SQL Developer and it works fine there, but VSCode version seems to hit a limit and it will not show the full result. I'm sure what I'm doing doesn't happen that often, but we were needing the json for the current project. The query will work just fine, but VSCode just doesn't like to display it.

VSCode Extension: 26.2.0

SQL Developer: 24.3.1.347 / Build: 347.1826

Comments
Post Details
Added on Jul 27 2026
1 comment
69 views