I am using DataGrip 2023.2 with Oracle 19c OnPrem Database (Oracle E-business Suite R12.2.11). I have full APPS access to my database and able to perform SQL queries. However, my intention is to open existing packages and make code changes in it.
Unfortunately even after lot of trial and error and online research, I am not able to open any package specification or body in the editor. I can see the package in the database explorer but when I double click it or use Go To Implementation or Go To Declaration, only below mentioned opens up in the console editor and does not show any code in it. Maybe I am doing something wrong, but I have run out of options to figure it out, hence seeking help.
Introspection keeps on running without any results.
-- auto-generated definition
create package AMS_ADI_PRETTY_URL_PVT as
-- no source code
Is there a simple way to open an existing package spec and body from Oracle Database in DataGrip? e.g. in Toad for Oracle, you select the package name and press F4 to open the definition and then you have option to load that into editor for editing it. Similar functionality exists in all other Oracle Database IDE tools like SQL Developed, PLSQL Developer etc.