Skip to Main Content

Oracle Developer Tools 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!

VSCode: go to/peek in pl/sql doesn't work with local sources

I vanApr 1 2023 — edited Apr 8 2023

I have two files:

api.pks.sql

create or replace package api is

function meaning_of_life return number;

end;

/

api.pkb.sql

create or replace package body api is
function meaning_of_life return number is
begin
return 42;
end;
end;
/

Go to and peek doesn't work on this local files. As I understand go to work only with DB connection.

It will be nice if extension work in two mode or have priority for offline sources / online sources.

In this case I'll expect that if I click GoTo definition in api.pks.sql It will open api.pkb.sql.

Some other extensions have this functionality, xyz.plsql-language for example but it can't be used both same time.

Comments
Post Details
Added on Apr 1 2023
3 comments
325 views