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!

Can't View/Edit Packages,Procedures, or Triggers

Someone else posted this issue but was told to start a new thread which I don't see so I will do it since I am having the same issue. I connect fine and can view/edit tables, views, and indexes. I can not view or edit Packages/Procedures. The trace debugging message when I click on a package it gives syntax error about expected identifier with the end command and it shows schema.package_name (schema name should not be in the end command). It is not how it is stored in database and if I use pl/sqldevloper (not vscode) and view the schema name is not there.

This was his post: (I'm on the same versions for database and extension)

I currently still get the same error. I cant view or edit Procedures/Packages either.

The error message is “An error occurred while fetching data”, then the connection closes.
Is there any known fix yet?

Kind Regards

Oracle DB Version: Oracle Database 19c Enterprise Edition.
Extension Version: v25.4.0

Comments
Post Details
Added 2 days ago
3 comments
48 views