Procedures for Combined Use - Firebird

Although it is possible to write a selectable procedure that executes a data-changing operation in the course of constructing an output set, it is not recommended. A selectable stored procedure is designed to output a set of data to the client, in the transaction context that invokes it. Until the client application has finished using that output set, the transaction remains uncommitted. If DML operations are included in the code that generates the output set, those DML requests remain uncommitted until the transaction is completed by the client.

In particular, data has the potential to be stored inconsistently if values from the stored procedure output are passed as parameters to operations in other transactions.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status

Firebird Topics