Subject How to call a STORED PROCEDURE in SQL statement : select ProcA(col1) from ...
Author kurgbe

Merry Xmas to all !

Firebird STORED PROCEDUREs cannot be called directly in the SELECT
part of a SQL statement.

For example, a procedure ProcA(arg1) that returns an integer, cannot
be called in the follwing way:

select col1, col2, ProcA(col3) from tableA; -- INVALID

I find this a real limitation. What is the reason for such a
behaviour? Will FIREBIRD V2 remove this limitation?

Is there a workaround in V1.5.x based only on the SELECT syntax?

If not, is an UDF (with low portability between OS) the only possibilty?