Hello there!
I’m using Oracle Database-19c-EE with the Oracle-SQL-Developer extension for VS-Code (v25.4.0). Whenever I try to browse a package or a stored procedure from the Schema Navigator, the worksheet shows the generic error “An error occurred while fetching data” and the connection is immediately closed. This behaviour occurs for both packages and procedures.
I’ve already verified that the database user has the required privileges (SELECT on ALL_OBJECTS, EXECUTE on the packages, etc.) and that the same user can view the objects without issue in the standalone Oracle-SQL-Developer client. The problem seems isolated to the VS-Code extension.
What I’ve tried so far:
Restart VS-Code and reload the extension – the connection still drops as soon as the object tree is expanded.
Update the extension to the latest version (25.4.1) and confirm that the VS-Code version itself is up to date.
Check the output console for the extension – I will post the output here.
Disable other extensions that might interfere with the Oracle extension – the issue persists.
Test with a different schema/user that has a minimal set of objects – the same error occurs.
Test viewing the object in the standalone Oracle-SQL-Developer client - it can be viewed without issues.
Has anyone encountered this exact error? Are there known work-arounds? If a downgrade to an earlier extension version resolves the issue, I’d appreciate the exact version number.
Any pointers, additional logs to capture, or configuration tweaks would be greatly appreciated. Thanks!
sql_developer_extension.log