Package Editor

Previous  Top  Next

Supported for


Packages are modules that contain multiple Stored Functions and Stored Procedures that can run on the server - thus without the network traffic involved in pulling data to a client and processing it there.


The Package Editor offers the possibility to create, alter and drop these modules. If you add or drop a package, the Packages node in the Database Navigator tree-view will display the change as well by adding or deleting the procedure from the list.


Below is an example of the Oracle Package Editor:

The Oracle Package Editor


The "{..}" button will turn the current line or text selection in the source editor box into a comment, or remove the comment from the current line.


At the bottom of the edit window, there's two tabs: Header and Body. If your package has both, you can use these to switch between them.


The Package Editor provides a Syntax Check by using the syntax check button in the toolbar, the bottom area of the Package Editor will display any errors and message.


See also: Object Template Editor