Oracle PL/SQL Packages

This article contains information about Oracle PL/SQL Packages, create , execute and drop packages and also predefined packages.

What is Package in Oracle PL/SQL?

Packages are a structure in which structures such as procedures and functions are gathered together.

Oracle packages definition consists of two parts: definition and body.

Create PACKAGE in Oracle PL/SQL

The keywords to be used when creating the package are as follows.

An example of creating a package with Oracle PL / SQL is as follows.

After making the necessary definitions for the package, the content of the structures such as procedure and function is written in the BODY section.

Execute PACKAGE in Oracle PL/SQL

We can access the package contents as follows.

For example, let’s run the MyLOOP procedure above.

Similarly, other objects in the package can be accessed.

The user_objects table is used to get information about the created packages.

The DESC keyword is used to get information about a package.

DROP PACKAGE in Oracle PL/SQL

The DROP keyword is used to delete the package.

Predefined Oracle PL/SQL PACKAGES

There are packages created for various processes within Oracle.

DBMS_OUTPUT in Oracle

This is the package used to display the data on the screen. You can find detailed information in the below link.

https://docs.oracle.com/database/121/ARPLS/d_output.htm#ARPLS036

DBMS_PIPE in Oracle

This is the package used to process between sessions. You can find detailed information in the below link.

https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_pipe.htm#CHDDFCFC

DBMS_LOCK in Oracle

This is the package in which user lock operations are performed. You can find detailed information in the below link.

https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_lock.htm#ARPLS021

DBMS_STANDART in Oracle

This is the standard package used in PL/SQL commands.

For example; The RAISE_APPLICATION_ERROR function is included in the DBMS_STANDART package.

The reason for using the packages, as can be understood from the examples, is the collection of commands that do interrelated work.

The use of packages for commands where the same or interrelated operations are performed will be useful for regular development.

You can find more detailed information about below topics in the below link.

PL/SQL Tutorial

You will find below topics in this article.

  1. What is PL/SQL
  2. Oracle PL/SQL Data Types and Variables and Literals
  3. Oracle PL/SQL Operators
  4. Oracle PL/SQL Conditional Statements
  5. Oracle PL/SQL Loops
  6. Oracle PL/SQL Procedures and Procedure Parameters
  7. Oracle PL/SQL Functions
  8. Oracle PL/SQL Cursor
  9. Oracle PL/SQL Records
  10. Oracle PL/SQL Exception
  11. Oracle PL/SQL Trigger
  12. Oracle PL/SQL Packages
  13. Oracle PL/SQL Collections

You can find more information about packages at docs.oracle.com

Yusuf SEZER
Author: Yusuf SEZER

Leave a Reply

Your email address will not be published. Required fields are marked *