FirebirdSQL logo
 EXTERNAL FUNCTIONPACKAGE BODY 

Examples of CREATE OR ALTER PACKAGE

Creating a new or modifying an existing package header
CREATE OR ALTER PACKAGE APP_VAR
AS
BEGIN
  FUNCTION GET_DATEBEGIN() RETURNS DATE DETERMINISTIC;
  FUNCTION GET_DATEEND() RETURNS DATE DETERMINISTIC;
  PROCEDURE SET_DATERANGE(ADATEBEGIN DATE,
      ADATEEND DATE DEFAULT CURRENT_DATE);
END
See also

[fblangref50-ddl-pkg-create], [fblangref50-ddl-pkg-alter], [fblangref50-ddl-pkg-recreate], ALTER PACKAGE BODY, RECREATE PACKAGE BODY

DROP PACKAGE

Drops a package header

Available in

DSQL

Syntax
DROP PACKAGE package_name
Table 1. DROP PACKAGE Statement Parameters
Parameter Description

package_name

Package name

The DROP PACKAGE statement deletes an existing package header.If a package body exists, it will be dropped together with the package header.If there are still dependencies on the package, an error will be raised.