Who Can Create A

PACKAGE BODYSEQUENCE

Who Can Create a `BLOB` Filter?

The DECLARE FILTER statement can be executed by:

Administrators
Users with the CREATE FILTER privilege

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

Examples of `DECLARE FILTER`

Creating a BLOB filter using subtype numbers.

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

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]