Subject Re: In a Firebird UDF, can you establish a connection back to the database?
Author tomsee7
--- In, "Steve" <steve_goa@...>

> I understand this, and am doing this in fact. However, I have a special requirement that the UDF further calls a stored procedure to retrieve some data from the database (it is an expression evaluator and calculator, whose input includes regular arithmetic expressions, and functions that depend on data from the database ).
> Yours sincerely,
> Steve Faleiro

It seems to me, naively perhaps, that all you want to do should be possible without resorting to this ill-advised technique.

Given you have both ends of the problem (i.e. database ddl & UDF) can you not simply return and interrogate values from the UDF that would then decide whether to invoke the stored procedure.