FirebirdSQL logo
 Data Manipulation (DML) StatementsBuilt-in Scalar Functions 
Exception Handling

When ON EXTERNAL is used, the extra connection is always made via a so-called external provider, even if the connection is to the current database.One of the consequences is that exceptions cannot be caught in the usual way.Every exception caused by the statement is wrapped in either an eds_connection or an eds_statement error.To catch them in your PSQL code, you have to use WHEN GDSCODE eds_connection, WHEN GDSCODE eds_statement or WHEN ANY.

Note

Without ON EXTERNAL, exceptions are caught in the usual way, even if an extra connection is made to the current database.
Miscellaneous Notes

  • The character set used for the external connection is the same as that for the current connection

  • Two-phase commits are not supported