Statement Types Not Supported
From InterBase
Go Up to Procedures and Triggers
The stored procedure and trigger language does not include many of the statement types available in DSQL or gpre
. The following statement types are not supported in triggers or stored procedures:
- Data definition language statements:
CREATE
,ALTER
,DROP
,DECLARE EXTERNAL FUNCTION
, andDECLARE FILTER
- Transaction control statements:
SET TRANSACTION
,COMMIT
,ROLLBACK
- Dynamic SQL statements:
PREPARE
,DESCRIBE
,EXECUTE
CONNECT/DISCONNECT
, and sending SQL statements to another databaseGRANT/REVOKE
SET GENERATOR
EVENT INIT/WAIT
BEGIN/END DECLARE SECTION
BASED ON
WHENEVER
DECLARE CURSOR
OPEN
FETCH