The Firebird 5.0 Language Reference | DECLARE EXTERNAL FUNCTION | Who Can Create An External Function Examples Using DECLARE EXTERNAL FUNCTION

Who Can Create an External Function

The DECLARE EXTERNAL FUNCTION statement can be executed by:

Administrators
Users with the CREATE FUNCTION privilege

The user who created the function becomes its owner.

Examples using `DECLARE EXTERNAL FUNCTION`

Declaring the addDay external function located in the fbudf module.The input and output parameters are passed by reference.
```
DECLARE EXTERNAL FUNCTION addDay
  TIMESTAMP, INT
  RETURNS TIMESTAMP
  ENTRY_POINT 'addDay' MODULE_NAME 'fbudf';
```

Declaring the invl external function located in the fbudf module.The input and output parameters are passed by descriptor.

DECLARE EXTERNAL FUNCTION invl
  INT BY DESCRIPTOR, INT BY DESCRIPTOR
  RETURNS INT BY DESCRIPTOR
  ENTRY_POINT 'idNvl' MODULE_NAME 'fbudf';

Declaring the isLeapYear external function located in the fbudf module.The input parameter is passed by reference, while the output parameter is passed by value.
```
DECLARE EXTERNAL FUNCTION isLeapYear
  TIMESTAMP
  RETURNS INT BY VALUE
  ENTRY_POINT 'isLeapYear' MODULE_NAME 'fbudf';
```
Declaring the i64Truncate external function located in the fbudf module.The input and output parameters are passed by descriptor.The second parameter of the function is used as the return value.
```
DECLARE EXTERNAL FUNCTION i64Truncate
  NUMERIC(18) BY DESCRIPTOR, NUMERIC(18) BY DESCRIPTOR
  RETURNS PARAMETER 2
  ENTRY_POINT 'fbtruncate' MODULE_NAME 'fbudf';
```

`ALTER EXTERNAL FUNCTION`

Alters the entry point and/or the module name of a user-defined function (UDF)

Available in

DSQL

Syntax

ALTER EXTERNAL FUNCTION funcname
  [ENTRY_POINT 'new_entry_point']
  [MODULE_NAME 'new_library_name']

Table 1. `ALTER EXTERNAL FUNCTION` Statement Parameters
Parameter	Description
funcname	Function name in the database
new_entry_point	The new exported name of the function
new_library_name	The new name of the module (`MODULE_NAME` from which the function is exported).This will be the name of the file, without the “.dll” or “.so” file extension.

The ALTER EXTERNAL FUNCTION statement changes the entry point and/or the module name for a user-defined function (UDF).Existing dependencies remain intact after the statement containing the change(s) is executed.

The ENTRY_POINT clause: is for specifying the new entry point (the name of the function as exported from the module).
The MODULE_NAME clause: is for specifying the new name of the module where the exported function is located.

Any user connected to the database can change the entry point and the module name.

Who Can Alter an External Function

The ALTER EXTERNAL FUNCTION statement can be executed by:

Administrators
Owner of the external function
Users with the ALTER ANY FUNCTION privilege

Examples using `ALTER EXTERNAL FUNCTION`

Changing the entry point for an external function

ALTER EXTERNAL FUNCTION invl ENTRY_POINT 'intNvl';

Changing the module name for an external function

ALTER EXTERNAL FUNCTION invl MODULE_NAME 'fbudf2';

`DROP EXTERNAL FUNCTION`

Drops a user-defined function (UDF) from the current database

Available in

DSQL, ESQL

Syntax

DROP EXTERNAL FUNCTION funcname

Table 1. `DROP EXTERNAL FUNCTION` Statement Parameter
Parameter	Description
funcname	Function name in the database

The DROP EXTERNAL FUNCTION statement deletes the declaration of a user-defined function from the database.If there are any dependencies on the external function, the statement will fail and raise an error.

Any user connected to the database can delete the declaration of an internal function.

Who Can Drop an External Function

The DROP EXTERNAL FUNCTION statement can be executed by:

Administrators
Owner of the external function
Users with the DROP ANY FUNCTION privilege

Example using `DROP EXTERNAL FUNCTION`

Deleting the declaration of the addDay function.

DROP EXTERNAL FUNCTION addDay;

Who Can Create An External Function Examples Using DECLARE EXTERNAL FUNCTION

Who Can Create an External Function

Examples using DECLARE EXTERNAL FUNCTION

ALTER EXTERNAL FUNCTION

docnext count = 5