{"id":1590,"date":"2017-12-01T15:35:47","date_gmt":"2017-12-01T08:35:47","guid":{"rendered":"https:\/\/oracletutorial.com\/?page_id=1590"},"modified":"2025-05-30T01:44:27","modified_gmt":"2025-05-30T08:44:27","slug":"plsql-package","status":"publish","type":"page","link":"https:\/\/www.oracletutorial.com\/plsql-tutorial\/plsql-package\/","title":{"rendered":"PL\/SQL Package"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn about the PL\/SQL package and the advantages of using the packages in application development.<\/p>\n\n\n\n

What is a PL\/SQL package #<\/a><\/h2>\n\n\n\n

In PL\/SQL, a package is a schema object that contains definitions for a group of related functionalities. A package includes variables<\/a>, constants<\/a>, cursors<\/a>, exceptions<\/a>, procedures<\/a>, functions<\/a>, and subprograms. It is compiled and stored in the Oracle Database.<\/p>\n\n\n\n

Typically, a package has a specification<\/a> and a body<\/a>. A package specification is mandatory while the package body can be required or optional, depending on the package specification.<\/p>\n\n\n\n

The following picture illustrates PL\/SQL packages:<\/p>\n\n\n\n

\"pl\/sql<\/figure>\n\n\n\n

Package specification #<\/a><\/h3>\n\n\n\n

The package specification declares the public objects that are accessible from outside the package.<\/p>\n\n\n\n

If a package specification whose public objects include cursors and subprograms, then it must have a body that defines queries for the cursors and code for the subprograms.<\/p>\n\n\n\n

Package body #<\/a><\/h3>\n\n\n\n

A package body<\/a> contains the implementation of the cursors or subprograms declared in the package specification. In the package body, you can declare or define private variables, cursors, etc., used only by the package body itself.<\/p>\n\n\n\n

A package body can have an initialization part whose statements initialize variables or perform other one-time setups for the whole package.<\/p>\n\n\n\n

A package body can also have an exception-handling part used to handle exceptions<\/a>.<\/p>\n\n\n\n

Why use PL\/SQL packages #<\/a><\/h2>\n\n\n\n

The package is a powerful feature of PL\/SQL that you should use it in any project. The following are the advantages of the package:<\/p>\n\n\n\n

Make code more modular #<\/a><\/h3>\n\n\n\n

Packages allow you to encapsulate logically related types, variables, constants, subprograms, cursors, and exceptions in named PL\/SQL modules. By doing this, you make each package more reusable, manageable, readable, and reliable.<\/p>\n\n\n\n

Hide implementation details #<\/a><\/h3>\n\n\n\n

Packages allow you to expose the functionality via their specifications and hide the detailed implementation in the package body.<\/p>\n\n\n\n

It means that you can enhance the code in the body of the package without affecting other dependent packages or applications.<\/p>\n\n\n\n

Improve application performance #<\/a><\/h3>\n\n\n\n

Oracle loads the package into memory the first time you invoke a package subprogram. The subsequent calls of other subprograms in the same package do not require disk I\/O. This mechanism helps improve performance.<\/p>\n\n\n\n

Minimize unnecessary recompiling code #<\/a><\/h3>\n\n\n\n

Packages help avoid the unnecessary recompiling process. For instance, if you change the body of a package function, Oracle does not recompile the subprograms that use the function, because the subprograms are only dependent on the package specification, not the package body.<\/p>\n\n\n\n

Manage authorization easily #<\/a><\/h3>\n\n\n\n

By encapsulating objects in a package, you grant roles on the package, instead of granting roles to each object in the package.<\/p>\n\n\n\n

PL\/SQL package concept is simple but powerful. They allow you to encapsulate the code and make your application easier to develop and maintain.<\/p>\n

\n\t
\n\t\t
Was this tutorial helpful?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t