How to Open Package in Toad for Oracle?

Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

April 26, 2023
Toad
1 min read

Follow these steps to open package in Toad for Oracle.

In Toad, click on menu Database > Schema Browser.
The schema browser window will open, then select the Packages from the drop-down menu or from the Tab.
Then list of packages will be displayed. Select the package you want to open and do the right click on it.
From the shortcut menu, click on Load in Editor > then select anyone of the following (Load Both, Load Spec Only, Load Body Only).
Then according to your selection the package will be open in the editor. There you can make the changes as well.