Updated on 2023-10-23 GMT+08:00

DROP PACKAGE

Function

DROP PACKAGE deletes the existing package or package body.

Precautions

After the package body is deleted, the stored procedures and functions in the package become invalid at the same time.

Syntax

DROP PACKAGE [ IF EXISTS ] package_name;
DROP PACKAGE BODY [ IF EXISTS ] package_name;