FirebirdSQL logo
  • Anglaiskeyboard_arrow_down
 PACKAGE BODYSEQUENCE (GENERATOR) 

Parameters

ENTRY_POINT

clause defining the name of the entry point (the name of the imported function) in the module.

MODULE_NAME

The clause defining the name of the module where the exported function is located.By default, modules must be located in the UDF folder of the root directory on the server.The UDFAccess parameter in firebird.conf allows editing of access restrictions to filter libraries.

Any user connected to the database can declare a BLOB filter.

Who Can Create a BLOB Filter?

The DECLARE FILTER statement can be executed by:

The user executing the DECLARE FILTER statement becomes the owner of the filter.

docnext count = 4

Examples of DECLARE FILTER

  1. Creating a BLOB filter using subtype numbers.

    DECLARE FILTER DESC_FILTER
  INPUT_TYPE 1
  OUTPUT_TYPE -4
  ENTRY_POINT 'desc_filter'
  MODULE_NAME 'FILTERLIB';

  2. Creating a BLOB filter using subtype mnemonic names.

    DECLARE FILTER FUNNEL
  INPUT_TYPE blr OUTPUT_TYPE text
  ENTRY_POINT 'blr2asc' MODULE_NAME 'myfilterlib';
See also

[fblangref50-ddl-filter-drop]

DROP FILTER

Drops a BLOB filter declaration from the current database

Available in

DSQL, ESQL

Syntax
DROP FILTER filtername
Table 1. DROP FILTER Statement Parameter
Parameter Description

filtername

Filter name in the database

The DROP FILTER statement removes the declaration of a BLOB filter from the database.Removing a BLOB filter from a database makes it unavailable for use from that database.The dynamic library where the conversion function is located remains intact and the removal from one database does not affect other databases in which the same BLOB filter is still declared.

Who Can Drop a BLOB Filter?

The DROP FILTER statement can be executed by:

  • Administrators

  • The owner of the filter

  • Users with the DROP ANY FILTER privilege

DROP FILTER Example

Dropping a BLOB filter.
DROP FILTER DESC_FILTER;
See also

[fblangref50-ddl-filter-declare]