Online Documentation for SQL Manager for Oracle
A package is an encapsulated collection of related procedures, functions, and other program objects stored together in the database. The package specification declares these objects. The package body, specified subsequently, defines these objects.
Packages are an alternative to creating procedures and functions as standalone schema objects.
Package Editor allows you to define package properties. It opens automatically when you create a new package and is available on editing an existing one.
To open a package in Package Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing package
- Browsing object dependencies
- Setting object permissions
- Viewing DDL definition