What are selectable Stored Procedures? - Firebird

“Selectable” stored procedures are so-named because they are written with some special language extensions to produce a multiple-row output set that is returned to the caller using a SELECT query—a “virtual table.”

The engine does not differentiate between an executable and a selectable stored procedure. If requested, it will try to form a set from an executable procedure or to execute something in a selectable procedure —and throw exceptions when the logic of the request fails, of course! It is up to you to make sure that your server code does what you intend it to do and that your client code submits appropriate requests.

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

Firebird Topics