Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"No Editor symbols." when parsing Oracle > 11.2, eg: CREATE OR REPLACE ** EDITIONABLE *** PACKAGE #90

Open
dokmanc opened this issue Mar 8, 2021 · 1 comment

Comments

@dokmanc
Copy link

dokmanc commented Mar 8, 2021

I am using Visual Code to view all of the database objects in our Oracle database that I scripted to files. I installed the extension "Language PL/SQL" found here:

https://marketplace.visualstudio.com/items?itemName=xyz.plsql-language

On the extension download website page mentioned above, if you look at the animate GIF, it gives the impression that if you type "@" in the command palette that the extension should list all of the procedures in an Oracle package that I have open, but instead it gives me a message under the popup: "No Editor symbols."

Is it someone possible to either jump to a procedure within a package or better yet, see an outline of the package so, as I scroll through it, I can tell which procedure I am currently in?

@dokmanc
Copy link
Author

dokmanc commented Mar 9, 2021

I found the issue:

I was using the Oracle function DBMS_METADATA.GET_DDL to get the DDL for a package. If you don't pass a version number into the function, the PACKAGES contain the word "CREATE OR REPLACE ** EDITIONABLE *** PACKAGE . The extension as choking on the word EDITIONABLE. So, I told the GET_DDL function to give me version 11.2 compatible DDL and the extension was worked. See https://stackoverflow.com/questions/66537067/visual-code-lacking-functionality-for-viewing-oracle-packages/66539955#66539955

@dokmanc dokmanc changed the title issue listing procedures in a package: "No Editor symbols." "No Editor symbols." when parsing Oracle > 11.2, eg: CREATE OR REPLACE ** EDITIONABLE *** PACKAGE Mar 9, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant